Viewing 15 posts - 43,651 through 43,665 (of 49,571 total)
Lian Pretorius (10/22/2008)
Thanks Gail - That was awesome!
😀 Glad you enjoyed it.
October 22, 2008 at 1:26 am
Possibly the stats getting inaccurate. Run an update statistics with fullscan and see if that helps.
Post the stored proc's code?
October 21, 2008 at 9:13 am
Eugene (10/21/2008)
After you trace deadlock and get idea what is running (who is victim)you will probably wish to add indexes and try to use NOLOCK hint
I would suggest, once...
October 21, 2008 at 9:07 am
Eugene (10/21/2008)
Hi,You need t enable 2 traces:
DBCC TRACEON (3604)
DBCC TRACEON (1204)
1204 alone is enough. 3604 is used to direct output of some commands to the client. Good example is...
October 21, 2008 at 8:38 am
Enable traceflag 1204 (DBCC TRACEON (1204,-1) or add -T1204 to SQL's startup parameters). That will write the deadlock graph into the error log
The deadlock graph will show you exactly...
October 21, 2008 at 4:09 am
SQL ORACLE (10/20/2008)
Otherwise, you may include DBCC SHRINKDB command in your optimization.
If you don't mind the indexes been more fragmented afterwards than they were before the rebuild, then yes, you...
October 21, 2008 at 1:15 am
Not much. My .net skills are almost non-existent and I didn't have much trouble with the exam.
Make sure you're familiar with creating assemblies in SQL (CREATE ASSEMBLY ....). Make sure...
October 21, 2008 at 12:43 am
Then you should be set. That column value indicates that the log space is not been reused because a log backup is required. Once the log backup runs (check and...
October 21, 2008 at 12:38 am
rishgup (10/20/2008)
I have scedule transaction log back every weekend. nut still no use. Trans log file is growing day by day.
You need to backup the log a lot more than...
October 20, 2008 at 3:31 pm
I haven't done that course, but I have written the exam. I don't recall any of the .net languages showing up, though you do have to be familiar with creating...
October 20, 2008 at 3:30 pm
Which course/exam in particular?
October 20, 2008 at 2:13 pm
ggraber (10/20/2008)
October 20, 2008 at 1:50 pm
Maybe. Try an index there and see if SQL uses it.
October 20, 2008 at 8:47 am
Where do you want to put the server name?
Run the query on the server that the backups were made on and replace the placeholder
AND sysdb.name = 'MY_DB_NAME'
with your actual DB...
October 20, 2008 at 8:44 am
Yup. Row versioning is used by the DB engine internally, even if Snapshot isolation isn't enabled in any DB. Other things that use row versions:
Online index rebuilds
MARS
http://www.sqlmag.com/Articles/ArticleID/93465/93465.html
You'll need a SQLMag...
October 20, 2008 at 8:02 am
Viewing 15 posts - 43,651 through 43,665 (of 49,571 total)