Viewing 15 posts - 3,256 through 3,270 (of 5,685 total)
Fill factor only makes sense if you understand how SQL Server stores records. It stores in an object called a page, which when you're done with header information is...
May 3, 2011 at 2:09 pm
If you need to avoid lock escalation, don't go above 5000 rows per pass:
http://msdn.microsoft.com/en-us/library/ms184286.aspx
See about midway down for a description of when the thresholds are hit and locks escalate.
May 3, 2011 at 12:25 pm
vasamsettipradeep (5/3/2011)
I joined two tables but the problem is I want to join another table to this there is no any relation like match rows between these tables.
With no...
May 3, 2011 at 12:22 pm
Steve Jones - SSC Editor (5/3/2011)
For Virtual Restore it's very quick....
May 3, 2011 at 12:18 pm
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.10 to 20 Characters per Element:
B'narg! Whaaaa? After a point...
May 3, 2011 at 11:45 am
vinod.saraswat (5/3/2011)
Drive free space: 201GB
Db size : 133283.31 MB
Space available : 34094.38 MB
Drive free space (For tempdb) :601 GB
After the execution below are the observations
Drive free space: 187GB
Db...
May 3, 2011 at 11:32 am
Bad brain day indeed. Need to GROUP BY on the productId and sum the quantity. 🙂
May 2, 2011 at 3:35 pm
tfifield (5/2/2011)
Todd,This should give you what you want. It gives each order and its items for only orders that have the same items.
Todd, that can get fouled up by...
May 2, 2011 at 2:06 pm
ricer (5/2/2011)
Craig Farrell (5/2/2011)
Basically you're saying make sure my ID exists when...
May 2, 2011 at 12:48 pm
As Dave mentioned, please post the execution plans. The actuals by preference.
I noticed this: WHERE 1=1
This usually occurs when you're dealing with dynamic SQL builds. It looks like...
May 2, 2011 at 12:44 pm
SQLkiwi (5/2/2011)
Ninja's_RGR'us (5/2/2011)
You can always mail it to me if you want... I won't tell a soul :-).No, I am resisting casting further aspertions on Craig's mental health.
Thank you, I...
May 2, 2011 at 12:14 pm
GilaMonster (5/2/2011)
Ninja's_RGR'us (5/2/2011)
May 2, 2011 at 12:07 pm
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.
Same here... hence #1 for amount of...
May 2, 2011 at 12:06 pm
Syed Jahanzaib Bin hassan (5/2/2011)
I am shocked because you dont know about how to generate T-SQL script from SSIS for the maintenance
How to generate a T-SQL script from SSIS? ...
May 2, 2011 at 12:02 pm
Brandie Tarvin (4/29/2011)
GSquared (4/29/2011)
I tell people that my job description is specifically designed to see how fast a person's eyes can glaze over. The entertainment starts there.
I may have...
May 2, 2011 at 11:33 am
Viewing 15 posts - 3,256 through 3,270 (of 5,685 total)