Viewing 15 posts - 8,851 through 8,865 (of 49,552 total)
ramana3327 (6/1/2014)
I heard that for large table we can't use exist or not-exit will be problem.
And you tested that statement and confirmed it to be true?
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
June 1, 2014 at 2:19 pm
Why are you looking for an alternative to NOT EXISTS?
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
June 1, 2014 at 10:23 am
renitaj (5/31/2014)
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
June 1, 2014 at 10:22 am
sanjivvinaik (5/31/2014)
This issue is caused if log back is not taken before tlog file get full.
Lack of log backups don't cause negative used space.
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
June 1, 2014 at 10:19 am
Sequences sound like a good choice here.
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
June 1, 2014 at 10:17 am
ramana3327 (5/29/2014)
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
May 30, 2014 at 1:09 pm
If the indexes are absolutely identical, then it cannot matter which you drop because they are identical.
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
May 30, 2014 at 1:05 pm
A table variable, like any other variable, is only in scope until the end of the batch. If you run the table variable declare, then as another batch run the...
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
May 30, 2014 at 11:14 am
High memory utilisation is good. It means SQL is correctly using the resources that you've told it that it can use (via max server memory)
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
May 30, 2014 at 11:12 am
Michael_Garrison (5/30/2014)
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
May 30, 2014 at 11:11 am
The location does not exist. If it did, you wouldn't be getting this error:
The system cannot find the path specified.
You need to figure out where SQL is trying to create...
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
May 30, 2014 at 7:01 am
Without seeing some code, there's nothing anyone can do but guess.
In general, dynamic can be faster if you're encountering parameter sniffing problems or other problems related to an unstable...
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
May 30, 2014 at 6:33 am
The error log lists the NUMA setup. Post that.
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
May 30, 2014 at 5:52 am
SQLRNNR (5/29/2014)
Have some fun and enjoy the opportunity.On the side, will you be back June 14th or July 14th?
If Steve's managed to squeeze a 6 week break into a 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
May 30, 2014 at 3:21 am
Did you ever test the backup after it was made?
Restore it somewhere else and check as well.
Also, make sure you restored the right backup in the right place. 🙂
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
May 29, 2014 at 3:33 pm
Viewing 15 posts - 8,851 through 8,865 (of 49,552 total)