Viewing 15 posts - 43,636 through 43,650 (of 49,552 total)
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
October 20, 2008 at 3:30 pm
Which course/exam in particular?
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
October 20, 2008 at 2:13 pm
ggraber (10/20/2008)
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
October 20, 2008 at 1:50 pm
Maybe. Try an index there and see if SQL uses it.
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
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...
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
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...
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
October 20, 2008 at 8:02 am
Except that you can't repair a snapshot, as it's a read-only partial copy of a DB.
Books Online
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
October 20, 2008 at 4:39 am
Adi Cohn (10/20/2008)
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
October 20, 2008 at 4:19 am
oliver.morris (10/20/2008)
Thanks for your reply. Over the weekend I tried to restore the database, I wanted to restore it to say a couple of hours earlier so I clicked 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
October 20, 2008 at 3:42 am
oliver.morris (10/20/2008)
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
October 20, 2008 at 3:38 am
Viewing 15 posts - 43,636 through 43,650 (of 49,552 total)