Viewing 15 posts - 6,466 through 6,480 (of 49,552 total)
The where clause is filtering out some row that has a value that throws that error. With the where clause, the row is not in the resultset and the conversion...
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 11, 2015 at 3:46 am
No.
Main problem is that it's pretty unlikely for the last select to be the one that throws an error, so the error handling (which is pre-SQL 2005 style) is mostly...
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 11, 2015 at 3:44 am
What is this supposed to be doing?
You want this changing to an in-line table-valued function?
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 11, 2015 at 3:36 am
Brandie Tarvin (3/10/2015)
SQLRNNR (3/10/2015)
Jack Corbett (3/10/2015)
SQLRNNR (3/9/2015)
Jack Corbett (3/9/2015)
Grant Fritchey (3/9/2015)
By the way, Gianluca is a giant.
So this means if and when I meet Gianluca he'll...
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 11, 2015 at 2:48 am
There are definitely times when shrinking is fine. I actually have a scheduled weekly shrink job on my dev server. That said, if you're so space-constrained that you're repeatedly shrinking...
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 11, 2015 at 2:42 am
There is nothing at all in your code which ensures that multiple people won't get the same department number. Yes, you have an updlock, but since there's no transaction, it's...
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 11, 2015 at 2:38 am
Could you post a few more rows of sample data please?
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 10, 2015 at 8:05 am
Koen Verbeeck (3/10/2015)
To be honest, I wouldn't like to manage 2TB of data with standard edition (and possible 16GB of RAM).
The Standard Edition I could live with (if it was...
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 10, 2015 at 7:18 am
Where to start....
Well, firstly, that trigger won't even create, so it's going to be pretty hard to tell you what's wrong with the trigger that you're running, as it's clearly...
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 10, 2015 at 7:02 am
JarJar (3/10/2015)
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 10, 2015 at 3:33 am
Partitioning is not done for performance reasons. It's for data management, fast loads and fast deletes. It won't necessarily improve performance, it may, in fact, reduce performance.
If you're looking for...
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 10, 2015 at 3:15 am
Srl832 (3/10/2015)
I do not think I am getting right results.
Well you can start by removing the nolock hints, since they allow SQL to return incorrect results.
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 10, 2015 at 3:07 am
XactAbort removes the need to try/catch, but if you want multiple statements to be atomic (all succeed or all fail), you need an explicit transaction.
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 10, 2015 at 3:02 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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 10, 2015 at 2:53 am
The SQL parser does not and can not execute code. It's a parser. It encounters the same temp table being created twice, hence throws an error.
Solution: Create the temp 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
March 10, 2015 at 2:51 am
Viewing 15 posts - 6,466 through 6,480 (of 49,552 total)