Viewing 15 posts - 38,266 through 38,280 (of 49,552 total)
jimmycjen (6/22/2009)
I noticed the backup file size is always smaller than the actual database file.
Because the database file may have some empty space and the backups just contain 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
June 22, 2009 at 2:05 pm
sarvesh singh (6/22/2009)
for e.g in the below query what does the merge join do?
Force SQL to use a MERGE join to join the tables, regardless of whether a merge, loop...
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
June 22, 2009 at 2:03 pm
Grant Fritchey (6/22/2009)
Oh, lordy. That's too much like work. After about the third SELECT DISTINCT, I lost interest.
There are three select DISTINCT in there? I didn't even look that far,...
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
June 22, 2009 at 10:19 am
jimmycjen (6/22/2009)
Our database is already 90% fragmented.
Index fragmentation or file-system fragmentation?
Does SQL Server backup removes the fragmentation ?
All SQL backup does is read through the database file and...
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
June 22, 2009 at 10:19 am
Lynn Pettis (6/22/2009)
Isn't this, optimized cursor an oxymoron?? 😉
Optimised cursor = runs way slower than set-based code
Unoptimised cursor = runs way, way, way slower than set-based code
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
June 22, 2009 at 10:17 am
Should be about the same either way, providing none of them have an explicit transaction wrapped around the whole lot.
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
June 22, 2009 at 10:01 am
Anyone want to take a stab at 800+ lines of cursor-ridden, mostly uncommented code?
http://www.sqlservercentral.com/Forums/FindPost739170.aspx
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
June 22, 2009 at 9:57 am
sarvesh singh (6/22/2009)
I am not clear what Query hints and table hints do? When are they used?
Have you looked in SQL's Books Online? There's a relatively good description of all...
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
June 22, 2009 at 9:48 am
chris_wallace_000 (6/22/2009)
Thanks SSChampion - will do.
Who are you talking to? 😉
SSChampion is a forum title, like yours is "Forum Newbie"
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
June 22, 2009 at 9:39 am
Gaby Abed (6/22/2009)
A deadlock is where two blocks can't make nice (they block each other), and SQL Server kills the one that is taking up less resources?
That's one of...
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
June 22, 2009 at 9:14 am
I'm not an expert on IO or hardware.
Was there a hard power failure? If the caches aren't properly battery-backed, that can cause problems.
Make sure that the HBA drivers are...
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
June 22, 2009 at 9:12 am
No need to delete them. SQL only keeps a certain number (default 6) and automatically deletes the older ones. New error logs get created (and older ones deleted) whenever SQL...
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
June 22, 2009 at 9:11 am
chris_wallace_000 (6/22/2009)
06/09/2009 10:18:54,spid21s,Unknown,An error occurred during recovery preventing the database 'KentLive' (database ID 8) from restarting. Diagnose the recovery errors and fix them or restore from a known...
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
June 22, 2009 at 7:40 am
Not enough information.
If you want advice on indexing a query, please post at minimum the query, the table definitions and current index definitions as well as the execution plan for...
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
June 22, 2009 at 7:34 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
It would be far more useful if you...
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
June 22, 2009 at 7:32 am
Viewing 15 posts - 38,266 through 38,280 (of 49,552 total)