Viewing 15 posts - 48,076 through 48,090 (of 49,552 total)
It didn't change in 2005. I don't know about previous editions, because I started with SQL 2000, but 2000 also had no issues with null bit columns
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
December 10, 2007 at 6:01 am
Yeah, I saw it. I even read it, twice.
I'm commenting on the cursor as much for the benefit of anyone reading this who might otherwise think that's a good way...
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
December 10, 2007 at 1:22 am
Jeff Moden (12/9/2007)
Heh... yeah... I know what they're for... it just that lot's of folks use them for things they should be doing in T-SQL, but don't know how.
Tell me...
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
December 10, 2007 at 12:12 am
Functions are not allowed to have side effects. No data changes, no schema changes, no config changes.
Can you convert it to a stored procedure?
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
December 9, 2007 at 11:40 pm
I still need to convert some of my crappy string manipulation functions to CLR. I'm betting on a CPU usage reduction if nothing else.
There are things that can be done...
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
December 9, 2007 at 11:29 pm
Rob Reid (12/9/2007)
To handle multiple inserts I could have while looped through each record in the inserted calling the proc
Ow! Cursors (or while loops) in triggers are very bad...
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
December 9, 2007 at 11:25 pm
I my experience, the traceflag is the best way to get deadock info, as you don't need any form of monitoring running. You can see deadlock graphs in the error...
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
December 9, 2007 at 11:17 pm
TheSQLGuru (12/8/2007)
Stealing my thunder Gila! I already posted on that yesterday at 8:54. 🙂
I saw, I thought it was worth saying again in stronger terms.
Besides, isn't imitation 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
December 9, 2007 at 12:25 pm
It's a multiple choice and simulation exam. You won't have to write code. You may need to select the correct version of the command from a list, so you should...
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
December 9, 2007 at 12:01 pm
As for your original question.
On a insert, the inserted table will be populated and the deleted will be empty. On an update, both the inserted and deleted tables will be...
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
December 8, 2007 at 1:50 pm
I'm not sure why this is deadlocking, as statements within a transaction cannot block each other.
If you look through the deadlock graph, can you find any reference to a...
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
December 8, 2007 at 1:37 pm
Rob Reid (12/7/2007)
SELECT@TrigType= 'I', --for insert U=update
@RecordID= RecordID,
@ViewStatus = ViewStatus
FROM
INSERTED
That's not a good construct in a trigger. What happens when an insert affects more than one row?
Triggers fire once 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
December 8, 2007 at 1:34 pm
Run profiler against the SQL server that AS is connecting to. The deadlock's coming from the database, not AS.
You can alse try switching on traceflag 1204 (on SQL Server) so...
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
December 8, 2007 at 1:30 pm
Derek Dongray (12/7/2007)
Can anyone explain why the CTE works so differently from the temporary table and why SQL server doesn't optimise both the same way?
A CTE is essentially a...
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
December 8, 2007 at 1:24 pm
Ramesh (12/7/2007)
Christian Buettner (12/7/2007)
Hi Ramesh,what makes you sure that the order of the rows is guaranteed in your example?
Index
An index on a column does not guarantee that data will be...
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
December 8, 2007 at 1:21 pm
Viewing 15 posts - 48,076 through 48,090 (of 49,552 total)