Viewing 15 posts - 19,651 through 19,665 (of 49,552 total)
Yes, Cross Apply works, so does any DMV. What doesn't work is this:
SELECT sql_handle ,
text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY...
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 21, 2012 at 10:16 am
Lynn Pettis (3/21/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
March 21, 2012 at 9:55 am
The compat mode just affects how the query processor processes and checks certain T-SQL constructs. It's not about different behaviour (much), CheckDB does the same in a DB under compat...
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 21, 2012 at 9:48 am
Brandie Tarvin (3/21/2012)
May I just say that, according to Salary.com, I am not wasting my time by posting to The Thread.http://business.salary.com/why-how-your-employees-are-wasting-time-at-work/%5B/url%5D
The link, it is broken. This one maybe: http://business.salary.com/why-how-your-employees-are-wasting-time-at-work/
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 21, 2012 at 9:38 am
The showplan events don't have durations or the like, so they can't be filtered. Nasty problem.
What I've recommended in the past is a 2-phase approach. Trace first for the procedures...
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 21, 2012 at 6:17 am
The command is
RESTORE DATABASE <database name> WITH RECOVERY
However you can only do that if mirroring is completely removed and once done you can't resume mirroring.
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 20, 2012 at 4:38 pm
SQLKnowItAll (3/19/2012)
Do you think a MS developer sat down and created these in an SSMS window and then executed them?
Yes, though it's more likely something like Query Analyser...
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 20, 2012 at 4:25 pm
If you've stopped mirroring completely, you can run RESTORE DATABASE <database name> WITH RECOVERY, but to restart mirroring after that you'd need to set up from scratch, restoring a new...
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 20, 2012 at 4:24 pm
The mirror database is restoring and is unavailable. Can you explain more what you're trying to do?
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 20, 2012 at 4:15 pm
Evil Kraig F (3/20/2012)
GilaMonster (3/20/2012)
I have a number of physics courses, a couple of astrophysics, one or two philosophy and a calculus one queued up to watch.
My hats off 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
March 20, 2012 at 3:13 pm
You don't need to run profiler traces or to restart the SQL Server at all. The traceflag that you referenced is very, very light weight and will cause no hassle...
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 20, 2012 at 3:09 pm
jcb (3/20/2012)
I had found:
WHERE (key1 = @key1 AND @key1 IS NOT NULL)
OR (key2 = @key2 AND @key2 IS NOT NULL)
OR (key3 = @key3 AND @key3 IS NOT NULL)
makes better execution...
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 20, 2012 at 2:55 pm
DDL triggers won't pick up a truncate, neither will DML triggers.
Have you considered Extended Events?
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 20, 2012 at 12:38 pm
Don't give users DDL Admin or above permissions.
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 20, 2012 at 11:54 am
Sean Lange (3/20/2012)
Same here. I figure with a single parameter that either of these would perform reasonably well.
Depends. Even with one parameter the IF is prone to erratic plans. Depending...
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 20, 2012 at 11:34 am
Viewing 15 posts - 19,651 through 19,665 (of 49,552 total)