Viewing 15 posts - 31,261 through 31,275 (of 49,552 total)
JRoughgarden (8/13/2010)
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
August 13, 2010 at 5:41 am
Several of the exams for that cert have expired and more of them are expiring this year. The MCSE is only for Windows server 2003, for the later versiosn it's...
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
August 13, 2010 at 5:06 am
Also
SELECT @@version
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
August 13, 2010 at 4:59 am
Deny them any rights on it. If they have no permissions on the procedure, they can't see that it even exists.
If you had managed to delete from sys.objects, you would...
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
August 13, 2010 at 4:52 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in 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
August 13, 2010 at 4:31 am
Where did the backup come from? What version of SQL and what tool? Where are you restoring it? What version of 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
August 13, 2010 at 4:30 am
You cannot change the system tables on SQL 2005+ You shouldn't event be considering changing the system tables unless you are happy with the possibility of having a corrupt 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
August 13, 2010 at 4:27 am
Please note: 2-year old thread.
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
August 13, 2010 at 4:19 am
kscott-851323 (8/12/2010)
I want to create a temporary table using a While Loop instead of a Cursor.
Why? If you're trying to remove the cursor, a while loop is no better....
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
August 13, 2010 at 12:34 am
If you add an appropriate index, you won't be searching the entire table.
I suspect this is one of the interview questions where there's no right or wrong. They want 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
August 13, 2010 at 12:32 am
JRoughgarden (8/12/2010)
You can also get multiple copies if the sproc does conditional logic within. Depending on the branch taken, different plans result.
When a plan is compiled and the proc contains...
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
August 13, 2010 at 12:17 am
If you're in a hurry and have no idea where to start, consider getting someone in to do a performance review, do some tuning and teaching.
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
August 12, 2010 at 12:32 pm
SQL Server 2008 Query Performance Tuning Distilled
Books alone aren't going to make you an expert. Practice does that. Lots of practice.
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
August 12, 2010 at 12:29 pm
Peter Trast (8/12/2010)
I missed it!!! I was in New Orleans this year...
TechEd Africa, not TechEd North America.
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
August 12, 2010 at 11:35 am
I'm fond of running it before my full backups (providing there's enough time available). That way I know I'm not backing up a corrupt database.
My personal rule-of-thumb - CheckDB should...
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
August 12, 2010 at 11:32 am
Viewing 15 posts - 31,261 through 31,275 (of 49,552 total)