Viewing 15 posts - 47,251 through 47,265 (of 49,552 total)
Can you also post the execution plans from the 2005 servers (saved as .sqlplan files, zipped and attached to post please)
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
February 28, 2008 at 9:30 am
The only option other than dynamic SQL (which you said you don't want) is to look up one of the split functions here (should be one in the script section)...
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
February 28, 2008 at 9:26 am
Jeff Moden (2/28/2008)
Um... star schema's? Isn't there a sidewalk like that somewhere in Hollywood? 😀
Might be. I know I've heard something about something like that. Will have to check...
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
February 28, 2008 at 9:13 am
Mark Markov (2/28/2008)
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
February 28, 2008 at 9:12 am
I tried that on sQL 2005 SP2.
Msg 8120, Level 16, State 1, Line 6
Column 'a.a2' is invalid in the select list because it is not contained in either an aggregate...
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
February 28, 2008 at 9:06 am
When I'm interviewing, I ask questions on any or all of the below topics, depending what position I'm interviewing for.
Indexes - types, differences.
Statistics - what, why
Database corruption - how to...
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
February 28, 2008 at 9:06 am
p.s. You should also try and work out why the corruption occurred. Did you have a server crash? Are you gtting any errors from the hard drives? etc
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
February 28, 2008 at 8:57 am
Sugesh Kumar (2/28/2008)
Run the DBCC CHECKDB with repair option to get rid of those errors.
Rather don't. Repair should be the last resort for fixing corruption, not the first.
The best way...
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
February 28, 2008 at 8:51 am
First thing you need to do is to identify why the web site is slow. Once you've found the cause of the slowness, it's often fairly easy to fix.
Performance monitor...
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
February 28, 2008 at 12:06 am
And after that, take a full database backup.
Backup log with truncate breaks the log recovery chain, meaning you'll no longer be able to restore to a pouint in time...
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
February 27, 2008 at 11:58 pm
In simple recovery mode, all transactions are fully logged.
When the transactions have committed, and the dirty data buffers have been flushed to disk, the log entries are marked inactive...
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
February 27, 2008 at 11:56 pm
At the event I went to, there weren't even any CTP dvds/cds. Guess I'll have to download it myself...
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
February 27, 2008 at 11:36 pm
The LSNs wouldn't match. SQL won't do the log restore.
Besides, if there's no full backup ever been taken, you can't do a log backup.
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
February 27, 2008 at 11:24 pm
You are corrct, just note that only a transaction log backup truncated the inactive portion of a llog. A database backup does not.
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
February 27, 2008 at 11:23 pm
Ad-hoc queries are also compiled and their plans cached.
The increased time may also be due to SQL populating the data cache. On the first read, data must be read from...
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
February 27, 2008 at 11:21 pm
Viewing 15 posts - 47,251 through 47,265 (of 49,552 total)