Viewing 15 posts - 2,791 through 2,805 (of 19,560 total)
barsuk (6/19/2014)
5.In case if any database rollback process takes forever.
Not for the Prod env of course. But for Dev or UAT, when Database can be easily restored from the backup,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 20, 2014 at 7:47 am
SQLalchemy (6/19/2014)
Thanks for the help and the directing me towards a temp table solution... one twist - a new form of data:
Fwiw - the use of tempdb is just for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 12:16 pm
You can query the plan cache.
You can run a server side trace.
or you could try something like this
SELECT TOP 10
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 10:22 am
ramrajan (6/19/2014)
cant it can be rewritten without looking at the data and resultset
Sure go ahead. But you are missing the point.
Those two joins are DIFFERENT. The reason they...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 9:12 am
ramrajan (6/19/2014)
Question 2 : Why we need two join below can we rewrite with single join is that possible.
LEFT OUTER JOIN dbo.subsystem subsys WITH...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 9:02 am
That would be normal because the subscription is expecting the value to be present. Since it is not, you are getting a null in return and the whole value...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 9:00 am
Stuart Davies (6/19/2014)
Sean Lange (6/19/2014)
SQLRNNR (6/19/2014)
JAZZ Master (6/19/2014)
SQLRNNR (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
djj (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
Stuart Davies (6/19/2014)
rhythmk (6/19/2014)
Stuart Davies (6/19/2014)
BWFC (6/19/2014)
MethodTechnique
Procedure
Stored
Function
Script
Visual Basic
Visual Studio
Management Studio
Studio...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 8:56 am
JAZZ Master (6/19/2014)
SQLRNNR (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
djj (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
Stuart Davies (6/19/2014)
rhythmk (6/19/2014)
Stuart Davies (6/19/2014)
BWFC (6/19/2014)
MethodTechnique
Procedure
Stored
Function
Script
Visual Basic
Visual Studio
Management Studio
Studio 54
Area 51
Lamaze
Childbirth
Alien
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 8:48 am
ramrajan (6/19/2014)
INNER JOIN dbo.controllersystem cs WITH (NOLOCK)ON sl.SubLocationId IS NULL
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 8:21 am
Koen Verbeeck (6/19/2014)
rhythmk (6/19/2014)
A newly hired developer who works remotely has asked for permission to run Profiler so he can see the reads/writes used by his queries...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 8:08 am
GilaMonster (6/19/2014)
The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.
+1
At least it provides an additional teaching moment :hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 8:08 am
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
djj (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
Stuart Davies (6/19/2014)
rhythmk (6/19/2014)
Stuart Davies (6/19/2014)
BWFC (6/19/2014)
MethodTechnique
Procedure
Stored
Function
Script
Visual Basic
Visual Studio
Management Studio
Studio 54
Area 51
Lamaze
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 7:48 am
Sean Pearce (6/19/2014)
mod: removed dead link
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2014 at 7:36 am
Sean Lange (6/18/2014)
Ed Wagner (6/18/2014)
Sean Lange (6/18/2014)
Ed Wagner (6/18/2014)
sing4you (6/18/2014)
SQLRNNR (6/18/2014)
Sean Lange (6/18/2014)
Ed Wagner (6/18/2014)
JAZZ Master (6/18/2014)
SQLRNNR (6/18/2014)
Ed Wagner (6/18/2014)
SQLRNNR (6/18/2014)
Sean Lange (6/18/2014)
whereisSQL? (6/18/2014)
Ed Wagner (6/18/2014)
JAZZ Master (6/18/2014)
Stuart Davies (6/18/2014)
bcsims...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2014 at 3:20 pm
Just before the spam started, I noticed some pages had a compromised php page on them. SSC was trying to download it to my system. The virus scanner...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2014 at 3:01 pm
Viewing 15 posts - 2,791 through 2,805 (of 19,560 total)