Viewing 15 posts - 27,391 through 27,405 (of 49,552 total)
select * from fn_trace_gettable( <trace filename> , <number of rollover files to read> )
You can get the name by querying sys.traces
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
March 14, 2011 at 3:39 am
You could check the default trace, I'm not sure if enabling/disabling triggers is in there. It's also not a long-term history. SQL rolls the files over once they get too...
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
March 14, 2011 at 2:11 am
This is at play: http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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
March 13, 2011 at 3:05 pm
Randheer (3/13/2011)
check out basic interview questions on http://sqlserverquest.blogspot.com
You might want to check the accuracy and readability before you go promoting those questions for people to use in interviews.
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
March 13, 2011 at 12:34 pm
Server Objects -> Triggers for server level triggers, Programability -> Database triggers for database scoped triggers.
My guess, on the failed drop you left off the 'ALL 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
March 13, 2011 at 12:33 pm
The message about user options is not an error, it's just an informational message.
Is there no other information anywhere?
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
March 13, 2011 at 12:20 pm
And what code are you using to drop 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
March 13, 2011 at 12:19 pm
Other than the few operations that can be minimally logged (see Books Online, Operations that can be minimally logged), it fully logs everything. So most inserts, all updates, all deletes...
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
March 13, 2011 at 3:35 am
Attaf_T (3/13/2011)
1- Is (Shrink database or Shrink files) speed up the queries or update ?
No. Generally it will sow queries down due to fragmetnation
2- Is (Shrink database or Shrink...
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
March 13, 2011 at 3:30 am
Rich Yarger (3/12/2011)
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
March 13, 2011 at 3:30 am
Jeff Moden (3/12/2011)
...because you can't rebuild nonclustered indexes unless there's a clustered index on the table.
????
You can't rebuild the table (to eliminate forwarding pointers or compact pages) if there's no...
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
March 13, 2011 at 3:25 am
Just one last point
Rich Yarger (3/12/2011)
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
March 12, 2011 at 4:39 pm
Where's the clustered index? Any reason the PK was made nonclustered?
Can you post the execution plan 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
March 12, 2011 at 2:53 pm
Rich Yarger (3/12/2011)
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
March 12, 2011 at 2:52 pm
Rich Yarger (3/12/2011)
By this I mean, what should the starting sizes be for master, msdb, model, and temp.
Master, model and msdb you can leave at...
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
March 12, 2011 at 1:49 pm
Viewing 15 posts - 27,391 through 27,405 (of 49,552 total)