Viewing 15 posts - 40,846 through 40,860 (of 49,571 total)
What version of SQL do you have on your home PC? (run SELECT @@version)
February 23, 2009 at 7:18 am
ushasheokand (2/23/2009)
February 23, 2009 at 7:12 am
Job postings belong in the jobs forum please, not repeatedly posted all over the site.
February 23, 2009 at 12:53 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
February 23, 2009 at 12:51 am
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?
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...
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
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...
February 22, 2009 at 3:07 pm
David.Poole (2/22/2009)
9 = Not applicable
?????
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...
February 22, 2009 at 11:35 am
Please post new questions in a new thread.
Thanks.
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...
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...
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...
February 22, 2009 at 1:35 am
Viewing 15 posts - 40,846 through 40,860 (of 49,571 total)