Viewing 15 posts - 47,266 through 47,280 (of 49,571 total)
The _WA_sys aren't indexes. They're automatically created column statistics. Nothing more.
They're created to help the optimiser determine the number of rows that queries should return. They're created on columns that...
February 28, 2008 at 10:45 pm
KATHLEEN Y ZHANG (2/28/2008)
somehow a proc I created to monitor blocking shows 'create proc' on the blocking side and 'execute' on the blocker side. I am not sure why.
How...
February 28, 2008 at 10:38 pm
lucky (2/28/2008)
I'll be having an interview tomorrow and I would like to get some hot tips
Sure.
Be honest about your level of knowledge. Any competant interviewer can tell knowledge from...
February 28, 2008 at 10:36 pm
Yup. I've seen that before.
Had an old DB that we found corruption in. Had no idea how long it had been there, and the earliest backup we had was...
February 28, 2008 at 10:31 pm
Can you also post the execution plans from the 2005 servers (saved as .sqlplan files, zipped and attached to post please)
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)...
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...
February 28, 2008 at 9:13 am
Mark Markov (2/28/2008)
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...
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...
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
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...
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...
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...
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...
February 27, 2008 at 11:56 pm
Viewing 15 posts - 47,266 through 47,280 (of 49,571 total)