Viewing 15 posts - 36,631 through 36,645 (of 49,552 total)
Expand out object explorer, click in 'Columns' of the table, drag that to the query window.
I know RedGate's SQLPrompt expands out *, but it's not free.
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
September 2, 2009 at 1:18 am
What more are you looking for?
When SQL detects a deadlock it picks one of the processes as the victim, kills that process to release the locks and allows the other...
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
September 2, 2009 at 1:17 am
riga1966 (9/1/2009)
So the Execution Time for this query is 855 ms?Is it the right approach overall?
Yup. The first execution time was for the first print. The second was for 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
September 1, 2009 at 1:16 pm
riga1966 (9/1/2009)
It looks like it diisplays results for 5 queries.
No, 4 queries.
The first is listed as parse and compile time, so it's the time to parse and compile the entire...
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
September 1, 2009 at 12:38 pm
Bob Hovious (9/1/2009)
Starts tomorrow for me, 2AM precisely.
Presenting or attending, Gail?
Neither. Sleeping.
The 1st of the 24 sessions starts 2AM tomorrow in my timezone, that's what I meant by 'starts'. Much...
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
September 1, 2009 at 11:48 am
jeremym (9/1/2009)
If it is shrunk beyond the size it needs to be won't it just allocate more space?
Yes, and that will force transactions to wait while the log is expanded...
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
September 1, 2009 at 11:43 am
Bob Hovious (9/1/2009)
Whups
😀
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
September 1, 2009 at 11:40 am
jeremym (9/1/2009)
From what I gather the the 0 is the same as unspecified and will decrease the file as much as possible.
Correct, but that is not a good...
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
September 1, 2009 at 11:20 am
Count the queries or add PRINT statements.
Did you check the articles I referenced? I'm sure this is mentioned in one of them
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
September 1, 2009 at 11:19 am
Apurva (9/1/2009)
I dont think even red gate has anyhting for readign the log. Not sure now.
They do, but only for SQL 2000.
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
September 1, 2009 at 11:03 am
rajdba (9/1/2009)
What you think we should do?
Wait or restart SQL. Those are your only options. Note that if you restart SQL and do not have 2005 Enterprise edition, 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
September 1, 2009 at 11:02 am
jeremym (9/1/2009)
I think what I am going to do is script it for an as needed use using the DBCC SHRINKFILE (N'DBName_LOG' , 0, TRUNCATEONLY) command.
No!
Firstly, truncateonly 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
September 1, 2009 at 10:30 am
Bob Hovious (9/1/2009)
Good luck with your 2 a.m. presentation, Gail.
What 2am presentation?
p.s. right thread for this question?
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
September 1, 2009 at 10:26 am
Elliott W (9/1/2009)
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
September 1, 2009 at 10:19 am
Elliott W (8/31/2009)
If you stop and start SQL I can almost guarantee your database will be corrupted.
Not at all. If you stop SQL and restart it, it will still...
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
September 1, 2009 at 10:16 am
Viewing 15 posts - 36,631 through 36,645 (of 49,552 total)