Viewing 15 posts - 16,531 through 16,545 (of 49,552 total)
Roland Alexander STL (9/21/2012)
Which is the point of using local variables, since it will force a new plan each time the query is run.
Errr... really?
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
September 21, 2012 at 9:41 am
If it is a table lock, it's probably because you don't have an index on the Product column.
Tune indexes, optimise code, then and only then try to outsmart the lock...
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
September 21, 2012 at 9:37 am
As I said, no. It is a specific solution to a specific problem.
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
September 21, 2012 at 9:16 am
PiMané (9/21/2012)
Is this the best way to optimize the query plan?
No. It's a specific solution to a specific problem.
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
September 21, 2012 at 9:02 am
Abu Dina (9/21/2012)
Google DBCC SHRINKFILE
And after you've done that, find the kb article that advises not to shrink TempDB and 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
September 21, 2012 at 8:54 am
Extension doesn't matter. You could call a SQL backup file readme.txt and it would still be a SQL backup file. If those are log backups, you can restore them 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
September 21, 2012 at 8:50 am
PiMané (9/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
September 21, 2012 at 5:48 am
stevro (9/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
September 21, 2012 at 5:36 am
If SQL is using too much memory, reduce max server memory. Unless you're doing odd things with CLR, the non-buffer memory shouldn't be that high.
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
September 21, 2012 at 5:30 am
There's also the MCSE for BI. Requires the MCSA and 2 more exams.
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
September 21, 2012 at 3:06 am
Normal, expected behaviour. Max server memory sets the size of the buffer pool. SQL also uses something called non-buffer memory which is outside the buffer pool and hence over and...
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
September 21, 2012 at 3:05 am
The score report comes in the post. Eventually. Mine took over a month to arrive.
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
September 21, 2012 at 3:03 am
That's not an implicit transaction, that's auto-commit mode. Implicit transactions is when you have SET IMPLICIT TRANSACTIONS ON.
The create table doesn't roll back for the same reason the create table...
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
September 20, 2012 at 1:51 pm
manub22 (9/20/2012)
IN & NOT IN generally should be avoided and only be used when filtering some set of values or constants.
Why?
IN & NOT IN may return incorrect data while dealing...
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
September 20, 2012 at 1:07 pm
David Moutray (9/20/2012)
Somehow I think SELECT LEN('a') is too simple for Dave's competition. There must be some really obscure way of returning a 1.
I can think of several hundred...
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
September 20, 2012 at 1:04 pm
Viewing 15 posts - 16,531 through 16,545 (of 49,552 total)