Viewing 15 posts - 1 through 15 (of 405 total)
It would be better for you to find this yourself by creating a load on your Dev server.
With out the included columns the plan may even ignore the new...
March 14, 2017 at 6:23 am
March 13, 2017 at 11:10 pm
It might be difficult to suggest an approach by an outsider who do not know any thing about the database and the application it supports.
But even then the basic...
March 13, 2017 at 11:01 pm
AWE is required only if you have 32 bit OS.
SQL server buffer cache can use memory that you have configured in Max Memory
You can use the total...
March 13, 2017 at 5:14 am
I use the following query to monitor my tables
Select SCHEMA_NAME(t.schema_id) SchemaName,t.name,s.rows,p.reserved_page_count*8.0/1024 SizeMB from
sys.partitions S join sys.tables t on s.object_id=t.object_id and
s.index_id in...
March 7, 2017 at 10:48 pm
certainly they are duplicate. The clustered index can benefit the same queries as the non clustered one. But there is a chance that someone might have created it intentionally for...
February 19, 2017 at 11:51 pm
February 17, 2017 at 2:41 am
Clustered index is the table, so you might want to recreate the index without the column, or you will end up with a heap table.
Since it is a Unique...
February 17, 2017 at 2:15 am
We should not convert the number from 300 to 300.0 because I have dynamic number...
February 8, 2017 at 4:14 am
Is the backup file good ?
Can you try
RESTORE VERIFYONLY FROM DISK = N'C:\SomeFolder\SomeBackup.bak'?
January 23, 2017 at 2:27 am
Also please look for any uncommitted transactions sysprocesses/ dm_exec_sessions
December 28, 2016 at 10:26 am
What is the maintenance you do on B?
does it affect the data?
And what type of replication have you configured?
December 20, 2016 at 9:50 am
In an execute SQL task get the status of a file to a variable, and in control flow precedence constraint, evaluate expression to check the value is success for...
December 20, 2016 at 9:23 am
You do not definition of the index as a script like that if that is what you are looking for.
You can right click the index in SSMS and script index...
December 15, 2016 at 4:50 am
Viewing 15 posts - 1 through 15 (of 405 total)