Viewing 15 posts - 31,201 through 31,215 (of 49,552 total)
SQL automatically resolves deadlocks as soon as it detects them. The error message that one gets is a notification that SQL detected the deadlock, resolved it by killing one session,...
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 17, 2010 at 6:41 am
Assuming you're using management studio...
In Object Explorer, right click the table, select script table -> Create -> To new query window. Now you've got the table's creation scripts.
Jeff's article covers...
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 17, 2010 at 6:39 am
Bhuvnesh (8/17/2010)
IS sys.dm_db_index_usage_stats not a DMV ?
Yes it is.
If you need to do something on insert/update/delete, I recommend triggers. That DMV is just to give info on how indexes...
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 17, 2010 at 6:19 am
Google is your friend
http://msdn.microsoft.com/en-us/library/ms179314.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
August 17, 2010 at 6:16 am
niyinks (8/17/2010)
No idea about the clustering but my last post describes the national table
My apologies, copied the wrong link and didn't notice (what I get for working on presentation 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 17, 2010 at 6:14 am
Well, the GO in the 'middle' of procedure A ends the batch. Hence leaving a begin without an end and, in the second batch an end without a begin.
GO is...
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 17, 2010 at 6:06 am
niyinks (8/17/2010)
pls clarify what you mean by table definitions
Please read the article I linked 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 17, 2010 at 6:01 am
Table definitions please, sample data and expected results.
Please read the article I linked 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 17, 2010 at 5:56 am
Is there a question here? Your code looks like it should work, just add an EXEC to run the dynamic sQL you generated.
I do have to ask... Why?
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 17, 2010 at 5:49 am
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 17, 2010 at 5:45 am
Why can't you use the DMV?
There's no really practical alternative. I suppose you could trace for the actual execution plans, load into a table and use xquery to see what...
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 17, 2010 at 5:41 am
Depending on how the database crashed. If SQL is still running and the transaction log is still available you can do a tail-log backup and back up right to 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 17, 2010 at 5:38 am
Well for restore purposes you have to restore PRIMARY, so by doing that you'll have all of your procedures.
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 17, 2010 at 5:24 am
Procedures are stored within one of the system tables, and the system tables are always on the Primary filegroup.
Why are you asking?
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 17, 2010 at 5:14 am
You can, it's a little more complex that way as you need to know the distribution of the data. I'd typically do it like this. (not tested!)
DECLARE @Done Bit;
Set @Done...
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 17, 2010 at 4:04 am
Viewing 15 posts - 31,201 through 31,215 (of 49,552 total)