Viewing 15 posts - 34,531 through 34,545 (of 49,552 total)
Profiler. Use the showplan_xml event
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
January 21, 2010 at 8:53 am
Aren't the differences what you'd expect?
With an inner join there must be a match in the second table, so the only rows that can appear in the resultset will have...
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
January 21, 2010 at 8:52 am
rick-507511 (1/21/2010)
hey, SSC-enthusiastic....
No one here by that name Grasshopper.
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
January 21, 2010 at 7:05 am
Lowell (1/21/2010)
you can use the old backwards compatible sysusers view or the newer sys.sysusers view in 2005 and above:
sysusers and sys.sysusers refer to the same view, a backward compatibility view...
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
January 21, 2010 at 7:05 am
Jeff Moden (1/20/2010)
I'd suggest the relatively new "master DBA" cert. I've forgotten exactly what's it's called but it's similar to what I've just called it.
Microsoft Certified Master
$18,000 fees
3...
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
January 21, 2010 at 5:38 am
You can use EXISTS to check the inserted and deleted tables.
If the trigger was fired by an insert, only the inserted table will be populated
If the trigger was fired by...
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
January 21, 2010 at 5:13 am
Looks like model is not where SQL is expecting it to be. Double check what you set model's location to when you moved it and whether the DB really is...
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
January 21, 2010 at 5:05 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic851107-149-1.aspx
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
January 21, 2010 at 5:02 am
bdba (1/20/2010)
... since columns KEY1 and KEY1 already have clustered index defined on them.
Yes, but....
While it is true that the clustered index keys are part of all nonclustered indexes, I...
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
January 21, 2010 at 1:27 am
Tom.Thomson (1/20/2010)
Can you delete it for me?
I can't. Only mods have the permissions to delete posts. If you wish, just edit it and remove (or alter) what you said.
I saw...
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
January 21, 2010 at 1:18 am
cos_ta393 (1/20/2010)
The thing is the application needs to be back online by tomorrow, AM.
You might want to have a word with your boss. The restart recovery will take as long...
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
January 20, 2010 at 2:32 pm
cos_ta393 (1/20/2010)
Yes the instance was restarted, sorry I wasn't clear about that.
People often do that without realising what they are doing.
An update (insert, delete) runs for too long. Someone panics,...
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
January 20, 2010 at 2:29 pm
If the database state is recovering then it means someone has already tried to cancel the rollback by restarting SQL server and found out that it didn't exactly help.
You have...
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
January 20, 2010 at 2:13 pm
I just wanted to make it clear to anyone that runs across the thread in the future that reboot is not the first thing to try for corruption, that's why...
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
January 20, 2010 at 1:40 pm
The error is because table names and aliases are scoped at the statement level. In your if statement you referenced p.AerialBy but, since the IF is a separate statement to...
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
January 20, 2010 at 1:26 pm
Viewing 15 posts - 34,531 through 34,545 (of 49,552 total)