Viewing 15 posts - 40,831 through 40,845 (of 49,552 total)
swmsan (2/22/2009)
Alter Database DBNAME Set Recovery Full.I get error 'Incorrect syntax near FULL.
The syntax is correct. Is that all that was in the query window?
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 23, 2009 at 12:49 am
Enable traceflag 1222. It causes the deadlock monitor to write a deadlock graph into the error log whenever a deadlock occurs. The graph will show both processes involved 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
February 23, 2009 at 12:47 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic662376-148-1.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
February 23, 2009 at 12:42 am
Are you trying to add the 1 - 12 columns for each row, or are you trying to aggregate multiple rows together?
The latter is what SUM is for. If...
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 22, 2009 at 3:07 pm
David.Poole (2/22/2009)
9 = Not applicable
?????
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 22, 2009 at 11:36 am
David.Poole (2/22/2009)
I'm also surprised that it isn't the default action for a backup and requires a DBA...
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 22, 2009 at 11:35 am
What backups?
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 22, 2009 at 11:27 am
Please post new questions in a new thread.
Thanks.
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 22, 2009 at 10:16 am
Yup, that should work.
Just one thing. What happens if the parameter is not string, into or decimal? May I suggest you make that a switch statement that covers all 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
February 22, 2009 at 10:16 am
Jaimin Patel (2/21/2009)
I have been working as DBA for 3 years and I want to get MCDBA certificate.
The MCDBA is an older cert. It was for SQL 2000 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
February 22, 2009 at 1:39 am
peace2007 (2/22/2009)
1. our server needs to be index tuned but it's too slow to run profiler.
Use a server-side trace. Much lighter weight than profiler
so I've queried DMVs a few...
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 22, 2009 at 1:35 am
Ok, that works, but...
Do you really want a second open connection, all the fun of distributed transactions and the like just to avoid a temp table? Plus you'd have 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 22, 2009 at 1:31 am
You can't select from a stored procedure. What you'll have to do if you want to go this kind of route is to define temp tables that match the results...
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 21, 2009 at 1:50 pm
What DDL changes?
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 21, 2009 at 1:45 pm
You will always have fragmentation, it's unavoidable. Small amounts (like in your example) is not a major concern. It's when inserts are all over the table (like Uniqueidentifier DEFAULT NewID()...
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 21, 2009 at 1:42 pm
Viewing 15 posts - 40,831 through 40,845 (of 49,552 total)