Viewing 15 posts - 136 through 150 (of 287 total)
Evil Kraig F (10/27/2011)
October 27, 2011 at 6:41 pm
That's a shotgun criticism. Could you be a little more surgical? 😀
If you're educated about proper indexing, the information Performance Dashboard provides can be used in a highly selective manner.
LC
October 27, 2011 at 5:05 pm
Have you ruled out any long executing SQL Agent jobs? Using SQL Server Management Studio, SQL Agent, Jobs, you can right click on each job to "View History" and see...
October 27, 2011 at 4:27 pm
jshurak,
It has been my experience that if a database management system is performing a high number of physical reads, then it must need the data it's retrieving from disk, since...
October 27, 2011 at 3:06 pm
I think you and I have different perspectives on things. I was a software developer for over 25 years, wrote about a half a million lines of source code in...
July 23, 2011 at 8:13 am
Performance Dashboard is an add-on feature for SQL Server.
Type this into Google and you'll get a bunch of hits: "sql server performance dashboard". Pick the selection that is appropriate...
July 22, 2011 at 12:49 pm
johnzabroski (7/22/2011)
July 22, 2011 at 12:19 pm
paul.starr (4/17/2009)
any info on really good interview questions for a sql server dba?
In addition to everything else that has been mentioned in this thread, I would recommend that you study...
June 21, 2011 at 4:43 pm
Jeffrey Williams-493691 (6/15/2011)
I have not validated the level of fragmentation after an insert, and a delete only leaves space available on the page and doesn't actually cause any fragmentation.
I agree....
June 16, 2011 at 7:58 am
Jeffrey Williams-493691 (6/14/2011)
ROW_OVERFLOW_DATA - Holds variable length data stored in varchar, nvarchar, varbinary, or sql_variant columns that exceed the 8,060 byte row size limit."
I believe the above is related to...
June 15, 2011 at 10:41 am
I am still researching this topic. From Books Online, index listing for "IN_ROW_DATA allocation unit":
"An Index Allocation Map (IAM) page maps the extents in a 4-gigabyte (GB) part of a...
June 14, 2011 at 4:54 pm
Thanks, Perry, for pointing me toward that article. And thanks, Jeff Moden, for writing the article on Tally tables. I'll be using that information in the future.
Jeffrey, I created a...
June 14, 2011 at 4:25 pm
Jeffrey,
I won't be convinced until I execute your code myself.
Reading further in Books Online, in the "Row-overflow data" index listing:
"Surpassing the 8,060-byte row-size limit might affect performance because SQL...
June 13, 2011 at 4:59 pm
Jeffrey,
I've read your email and it makes sense. However, I can't execute your code and I'd like to.
It is not intuitively obvious to me what a Tally table is. Please...
June 13, 2011 at 4:51 pm
Jeffrey Williams-493691 (5/20/2011)I also need to point out that the discussion concerning fill factor has left out one key point. If the table in question has any varchar columns,...
June 13, 2011 at 1:11 pm
Viewing 15 posts - 136 through 150 (of 287 total)