Viewing 15 posts - 286 through 300 (of 389 total)
Your biggest hint as to best candidate for clustered index is highest number of the sum of seeks grouped by the leading index key.
Also, a symptom of poor choice of...
April 19, 2015 at 5:07 pm
Eirikur Eiriksson (4/19/2015)
SQL-DBA-01 (4/19/2015)
Eirikur,Can you suggest how to use sample percent and other hints using sp_updatestats??????????....???????
The table which has billions of records do u suggest running sp_updatestats???????????????????????????????????????
Again reiterating the suggestion...
April 19, 2015 at 11:46 am
Eirikur Eiriksson (4/19/2015)
Quick question, why not use sys.sp_updatestats?😎
exactly what I put into his request for code review of updating stats using nested cursors posted on 7april. To DBA01, Instead of...
April 19, 2015 at 2:14 am
MMartin1 (4/17/2015)
then I tried it with temp tables (two temp tables then the join) and boom, total execution goes way way down.
not sure what is going on here but I...
April 18, 2015 at 4:05 am
To see how they are linked, go here.
<Download SQL Server 2008 System Views Map from Official Microsoft Download Center>
http://www.microsoft.com/en-us/download/details.aspx?id=9301
April 17, 2015 at 8:27 am
This might have good information of where to start trying to find this information.
<Download SQL Server 2008 System Views Map from Official Microsoft Download Center>
http://www.microsoft.com/en-us/download/details.aspx?id=9301
April 17, 2015 at 8:25 am
You need to
alter ixmyindex on mypatitiontable rebuild on partitionscheme(MycolumnIAmPartitioningBy)
Also your index rebuild jobs must be smart enough to rebuild onto the partitionscheme and not the default on primary else...
April 16, 2015 at 12:17 am
looking at your pivot, it seems it is trying to compare incidentid which may be an int column vs C1 or C2 or C3 or C4, which looks text.
Maybe...
April 15, 2015 at 3:28 pm
A little more info. Do you want all rows to be appended to each other into one long string.
Do you want to append multiple values for a particular column based...
April 15, 2015 at 2:54 pm
I think you should be left joining on all the conditions in the subquery.
Try this and see if it is any different.
SELECTm.lID
FROMMessage m
INNER JOIN Message_Cc mCC ON m.lID = mCC.lMessage...
April 15, 2015 at 5:56 am
What you can do to give Gail at least a bare minimum of information is either
1) select top 10 from sys.dm_exec_procedure_stats order by totalelapsedtime desc, and find the offending...
April 14, 2015 at 3:34 pm
Page splits are dependent on workload. Also checked around and everyone seems to say the same thing. Not a valid argument, i.e. Argumentum ad populum, but could be used as...
April 14, 2015 at 3:25 pm
Find your set options using your query
SELECT plan_handle, usecounts, pvt.set_options,text
FROM (
SELECT plan_handle, usecounts, epa.attribute, epa.value ,text
FROM sys.dm_exec_cached_plans
...
April 13, 2015 at 10:26 am
Keep in mind that your tables are indexes if they are clustered.
April 13, 2015 at 10:13 am
SHA2_256 is supported on 2012 and greater. ARe you running 2012 and is your compatibility level 110 or more?
April 10, 2015 at 10:32 am
Viewing 15 posts - 286 through 300 (of 389 total)