Viewing 15 posts - 17,911 through 17,925 (of 49,552 total)
Please post SQL 2000 questions in the SQL 2000 forums. Post in the 2005 forums and you will get answers that are specific to 2005 and above.
In SQL 2000 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
June 25, 2012 at 3:01 am
If you're talking about the SQL Server database engine, Paul's said before on Twitter that it's mostly C++ with some assembler
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
June 25, 2012 at 2:58 am
sql.AB (6/24/2012)
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
June 25, 2012 at 1:43 am
or Snapshot / read committed snapshot isolation.
Data modifications may still block
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
June 24, 2012 at 5:48 pm
Have a read through this, there's a section on monitoring TempDB, you can put a job in place to track the abusers of TempDB without having to sit and watch...
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
June 24, 2012 at 5:33 pm
The INDEX(1) hint forces SQL to use the clustered index (if there is one) for that query. It does not specify how the clustered index should be used, whether 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
June 24, 2012 at 5:16 pm
Take a step back.. Why can't you start the SQL service normally?
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
June 24, 2012 at 1:28 pm
Define 'lost'
What is the exact state of the SQL instance?
What did you do to the system databases? (neither checkDB nor updateusage will affect any database other than the one they...
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
June 24, 2012 at 11:01 am
The solution is not to try and shrink TempDB, but to size it correctly for the usage that you get. SQL will automatically drop temp tables as soon as they...
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
June 24, 2012 at 10:47 am
That won't work.
Only the connection that creates a temp table can drop it. That script will just give you a whole lot of errors.
Why do you want to clear TempDB...
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
June 24, 2012 at 8:43 am
Jake Shelton (6/24/2012)
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
June 24, 2012 at 8:38 am
Don't shrink the log regularly...
In bulk-logged recovery you're better off rebuilding the indexes than reorging, as rebuild is a minimally logged operation. Otherwise increase the frequency of your log 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
June 24, 2012 at 7:06 am
Update a large table.
However if you want to test the stability of the IO subsystem, shut SQL Server down and use SQLIOSim
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
June 24, 2012 at 6:22 am
The log will never reduce in size by itself
Please read through this - Managing Transaction Logs[/url]
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
June 24, 2012 at 5:38 am
Then you need to enable TDE (Transparent Database Encryption) on the database itself, or use a 3rd party tool that allows for encrypting 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
June 23, 2012 at 11:58 am
Viewing 15 posts - 17,911 through 17,925 (of 49,552 total)