Viewing 15 posts - 44,716 through 44,730 (of 49,552 total)
Then you're about 90% safe to drop the indexes that the tuning wizard doesn't want.
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
September 2, 2008 at 1:42 pm
Not unless you have some form of auditing in place already.
Did someone perhaps delete and recreate the 'object'? If you have cascading delete, that may have caused 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
September 2, 2008 at 1:03 pm
*RotFL* :hehe:
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
September 2, 2008 at 12:57 pm
Are you completely certain that the trace you have given the tuning wizard contains every single query that gets run against your SQl server, including any regular batch processes, month...
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
September 2, 2008 at 12:45 pm
How much memory on the server? What's SQL's max memory set to? Are there other apps on the server?
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
September 2, 2008 at 12:16 pm
I generally don't recommend that index tuning be done on an entire database at once. Too much opportunity for something to go wrong. i perfer to either tune indexes one...
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
September 2, 2008 at 11:44 am
Yes, however...
@@Error is set by every statement to the error that statement threw, or 0 if no error occured. In your example, if doSomething1 or DoSomething2 threw an error, 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
September 2, 2008 at 11:41 am
You can get just the user tables that have clustered indexes with this:
Select object_name(id), name From sysobjects Where xtype = 'u' AND objectproperty(id,'TableHasClustIndex')=1
and the user tables that don't have 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
September 2, 2008 at 11:34 am
Rather have a scheduled task that connects to the instance via windows authentication and runs the backup database task. Or create a login that only have permission to backup 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
September 2, 2008 at 11:31 am
Exactly what I'm using.
It's a pity. I want to like the 2008 intellisense, but it's irritating me. I can't find a way to change what triggers an auto complete,...
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
September 2, 2008 at 11:26 am
Please post this as a new thread in the SQL Server 2000 administration forum.
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
September 2, 2008 at 10:52 am
Too expensive.
I can understand why. Instructors don't come cheap and it it's 5 different instructors over a couple weeks, that is going to cost. Problem is, it's priced curently 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
September 2, 2008 at 4:10 am
You don't backup tables in SQL, you backup databases.
You can export the table as csv, or make a copy of it in another database
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
September 2, 2008 at 2:55 am
Can you please give us the table structure, some sample data and an example of what you want out?
Without that we're going to be guessing as to whether or not...
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
September 2, 2008 at 2:40 am
There isn't an undelete function. There's no history unless you have an audit-trail or similar. There's no built-in source control of any form in SQL.
Are you sure there's no backup...
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
September 2, 2008 at 2:19 am
Viewing 15 posts - 44,716 through 44,730 (of 49,552 total)