I was analyzing a query using "Database Engine Tuning Advisor". During this time the database started to get blocking, long running queries and ended by restarted the instance. When I checked after ...

I am trying to find the biggest / longest entries of a column which is of type nvarchar(100). I need to understand if I can maybe restrict that column to be only nvarchar(20) or something. Is there a ...

We currently have a SQL Server 2008R2 being accessed by a legacy ASP application.
Among different processes, one of them essentially SELECTs data from one database and INSERTs (or UPDATEs) them into ...

I faced with strange situation: inserting of ~800 000 rows into table variable is much more faster than inserting (with the same select) into temporary table. INSERT is under stored procedure. SELECT ...

I am trying to create partial indexes for a large (1.2TB), static table in Postgres 9.4.
My data is completely static, so I am able to insert all data, then create all indexes.
In this 1.2TB table, ...

I have searched thoroughly on how to improve general performance of my database which is hosted on Hostgator. I have mostly come across performance tuning strategies which are catered to only local or ...

I have a trigger applied to a table to write inserts and updates to a history table. That history table can grow pretty fast, and we want to see, if we can speed up insert operation a bit.
The values ...

I have a production web server with postgresql database.
My server gets data from another server every hour on the hour. The other server wakes up and sends many requests to my server, each result in ...

We are using MYSQL database for an Analytics app. I have two table token and token-big (for overview of actual data) both have id(int) unix_starttime(int) unix_endtime(int) details(varchar 256)
A row ...

In our project a datafile is loaded into SQLServer using Informatica. The source column is defined in Informatica as UniChar.60
The target column in SQL Server is defined as varchar(60)
But when the ...

we have a dedicated mysql server with 10 CPU and 32G of memory
After doing some readings came up with those configs :
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
...

Last year I wanted to move our critical SQL Server solution from Virtual to physical. I liked the Poweredge R720 with it's 2 RAID controllers and favoured filling it with 2.5" Samsung EVO SSDs - not ...

i have a big issue, every day i need to update or insert like 3.3 milion rows, i have trying to do what ever i can but it still only run like 605 query/s i use VirtualBox so my setup are testing on 1, ...

I am using MS SQL, and I have to run several queries on the same table on different criteria. At first I ran each query on the original table although they all share some filtering (i.e Date, status). ...

On a fairly busy SQL server, we sometimes need to do large index-building operations (after importing ~6GB tables). The indexes are built using the more efficient "Repair by sorting" method, rather ...

I'm trying to find/build a query to show me those queries that are consuming more resources in SQL Server so that I can optimize them or at least have a statistical idea of what is really happening.
...

I am running a very old server that has a database that is being permanently retired within 14 months. My company will not invest anymore in hardware or software for this system as we are moving to a ...

I have MS SQL Server with different size of RAM.
So I would like to control the values which are set for the RAM.
Somewhere I read a 'rule' to calculate the maximum of RAM.
These SQL Server are only ...

For one of my servers( SQL server 2008R2) we can continuously witness High Page Reads/sec during business hours say: from 7 AM to 9 PM EST.
I kept the counter settings to monitor the same and found ...

Imagine a database about 30GB in size using 3 data files on the same disk.
Someone told me to have one data file per processor implemented to get full performance on all cpus. So if I now add three ...