Viewing 15 posts - 2,791 through 2,805 (of 19,564 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,...
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...
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
...
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...
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...
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...
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...
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
June 19, 2014 at 8:48 am
ramrajan (6/19/2014)
INNER JOIN dbo.controllersystem cs WITH (NOLOCK)ON sl.SubLocationId IS NULL
...
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...
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:
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
June 19, 2014 at 7:48 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...
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...
June 18, 2014 at 3:01 pm
Viewing 15 posts - 2,791 through 2,805 (of 19,564 total)