Viewing 15 posts - 46 through 60 (of 691 total)
JohnSQLServerCentral (5/9/2011)
May 10, 2011 at 6:46 pm
Stefan Krzywicki (4/14/2011)
Was that you they were talking about? LOL. I had a feeling if I mentioned it here I might find out who it was.
No, I was just joking...
April 14, 2011 at 11:41 am
Interesting read.
I do have to question the idea that the 3-6 month BI project is a junior role and a good way for someone to "get their feet wet."...
April 14, 2011 at 11:02 am
bradmcgehee@hotmail.com (2/14/2011)
February 14, 2011 at 8:48 am
george sibbald (2/14/2011)
does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?
No. It's more of a server-wide picture, with occasional...
February 14, 2011 at 7:57 am
majorbloodnock (2/1/2011)
The technical logic is fine, but in practice, why shouldn't an employee have two managers?
Having actually had two managers (and then, later, three) at one point in my...
February 1, 2011 at 8:36 am
James Stephens (1/31/2011)
It's 2011. Why the heck doesn't Microsoft store AD information in a true relational db to begin with?
The newest versions of AD use SQL Server (or at...
January 31, 2011 at 11:55 am
CELKO (1/31/2011)
The best I have...
January 31, 2011 at 11:48 am
Mark-101232 (1/4/2011)
I don't think the CELKO method works correctly in all circumstances, the problem occurs when there are duplicates and the ASC and DESC ROW_NUMBERs don't match up.
Garbage in,...
January 4, 2011 at 10:05 am
Glad to hear that it worked!
Why did it cause a problem? Well, the fact is that XML indexes in SQL Server are really not well integrated with the query optimizer....
December 30, 2010 at 10:54 am
I'm getting a very different plan than you are -- and a much more efficient one at that. The biggest difference? My plan uses only the primary XML index, and...
December 30, 2010 at 10:38 am
Just to be clear, you run one file at a time, and it takes 8 minutes?
December 30, 2010 at 8:15 am
Can you post the schema of the actual table, a few rows of sample data, number of actual rows, and the query plans for both? I'm sure if the CROSS...
December 30, 2010 at 7:11 am
Perhaps this will help you?
December 29, 2010 at 8:53 am
Solomon Rutzky (12/29/2010)And that article was done before SQL Server 2008 added the ability to go beyond the 8k memory limit (with a MaxSize set to -1) so adding that...
December 29, 2010 at 8:41 am
Viewing 15 posts - 46 through 60 (of 691 total)