Viewing 15 posts - 35,821 through 35,835 (of 49,552 total)
kramaswamy (11/16/2009)
I take it then, that despite my original intuition, the leaf level is actually index level 0, not the highest index level?
Indeed. The leaf is level 0, the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 8:53 am
Ask the server administrator or whoever set up the physical server which drives are SAN drives and which ones are direct attached storage. Th SQL they look the same.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 8:49 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 8:48 am
Grant Fritchey (11/16/2009)
Direct from the horses mouth, the 1000 page number is arbitrary, not based on emperical evidence.
According to Paul, it was an estimate based on knowledge of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 8:46 am
When looking at index fragmentation, it's usually only necessary to look at the leaf level (level 0). The others are very often small and, especially for a frequently used index)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 8:44 am
You trying to create a database on there? Query a database on there? Exactly what are you doing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 2:06 am
I'd prefer to see the screenshot, to see exactly what the path has been set to, exactly what the filename has been set to. The script's just going to show...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 2:05 am
Aaahhhhhh!!!
http://www.sqlservercentral.com/Forums/Topic817076-146-1.aspx
Spoon feeding?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 1:48 am
Then go to "Edit Attachments" (it's part of the user control panel) and delete some of your old uploads.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 1:46 am
newbie2sql (11/15/2009)
One of our databases log file growing very huge. One of our team members recommended the following instead of dbcc shrinkdatabase (of course i would recommend...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 1:17 am
Not according to the error message you aren't.
Directory lookup for the file "e:\as.mdf\as.mdf" failed
Check what you've got set for the directory and what you have for the filename....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 1:10 am
obtllc (11/15/2009)
backup log database_name with truncate_only
Suggesting that with not mention of what it does, what the effects are and what you need to do afterwards? Bad advice.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2009 at 1:07 am
This looks like spam. An near exact copy-paste of part of the previous post, with advertising junk at the bottom.
In case it's not. Get your windows admins to look into...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 15, 2009 at 8:59 am
I can't remember the details, but I think it's a case where it's supposed to be accurate, but not 100% certain to be if there are ongoing changes and open...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 15, 2009 at 8:55 am
Also check out the Plan cache miss and plan cache insert events (also in profiler)
I don't recall if the SP:Recompile and TSQL:StmtRecompile show compiles or just recompiles. Test them out.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 15, 2009 at 4:32 am
Viewing 15 posts - 35,821 through 35,835 (of 49,552 total)