Viewing 15 posts - 47,896 through 47,910 (of 49,552 total)
Minimum permissions needed to access the server is CONNECT on the server. I think you get that by default on any login, though it can be revoked.
Change the user's default...
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
December 30, 2007 at 11:48 pm
Can you give an example of the output you want please?
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
December 30, 2007 at 11:41 pm
There's no tool in existance that can rewrite a query in the most optimal way, or list the 'correct' indexes for a table. That's why skilled DBAs are still needed.
Profiler...
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
December 30, 2007 at 11:33 pm
You'll have to query every table. There's no place where all data from all columns is stored, or anything like that.
You can use the system tables/information views to build up...
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
December 29, 2007 at 1:43 pm
Stats updates get triggered on a read. The updates just set the row mod. When a query is run against a table, the rowmodcnt is checked and, if necessary a...
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
December 29, 2007 at 1:34 pm
There's nothing you can really do to protect the server against the admins of that server. They have full control over the servers and possibly even the domain. Stealing your...
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
December 29, 2007 at 5:09 am
Do you want to prevent people from attaching data files, or from copying data files off the machine?
For the first, don't give db_creator rights to anyone. Sysadmins can do in,...
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
December 29, 2007 at 2:55 am
I did a quick check earlier. I couldn't see anything different with profiler, and the times were the same. I just don't know of any way to check system table...
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
December 28, 2007 at 2:08 pm
Yup. The indexes won't get fragmented during an upgrade. The stats need updating because SQL 2005 keeps more detailed stats than SQL 2000 did. The 2005 optimiser can use 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
December 28, 2007 at 1:52 pm
I'm going to reply to your PM here. A private message won't help anyone else, and also means that I'm the only one who can reply. There are lots of...
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
December 28, 2007 at 1:34 pm
Easiest way is to use a cursor. For each item found, call sp_helptext.
Set the output in management studio to text, then you can save the whole lot as a file
SET...
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
December 28, 2007 at 1:29 pm
EXEC sp_MSForEachTable 'UPDATE STATISTICS ? with fullscan; print ''?'' '
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
December 28, 2007 at 8:40 am
DBAhawk (12/28/2007)
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
December 28, 2007 at 8:35 am
Setting the DB to Truncate Log on Checkpoint means you've switched the recovery mode to Simple.
In Simple recovery mode, the inactive portions of the log are discarded once the data...
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
December 28, 2007 at 8:21 am
In 2005 only
SELECT TOP (@Variable) Columns FROM Table
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
December 28, 2007 at 8:13 am
Viewing 15 posts - 47,896 through 47,910 (of 49,552 total)