Viewing 15 posts - 1 through 15 (of 16 total)
Calculate these once and store them in a table - look them up when needed :)_
June 14, 2023 at 10:04 am
when ever I see a question from Andy, i think "what's the obvious catch"
which got me thinking, why is aliasing in trigger update not consistent? was the a red herring...
April 3, 2014 at 2:59 pm
fair point Jeff, I used the term "spill to disk" to mean "spill to tempdb" - that was an error on my part.
Let me re-phrase again 🙂
Why can't SQL SERVER...
October 30, 2013 at 6:01 pm
Hi Sean,
yep, your entirely correct, the sort is responsible for the spill to disk.
And thanks for pointing out that changing the column to a VARCHAR eliminates the spill.
I also found...
October 30, 2013 at 12:40 pm
Toreador (7/25/2011)
Richard Warr (7/25/2011)
We know that "ID" was really "ModelID"
Really. do we really.
We can only answer based on the question.
It's just a question. Not a test of your psychic ability...
July 25, 2011 at 3:52 am
I got the question correct, but I answered it on the basis that the two where clauses were different.
Where ID = 20 OR modelID = 20 --- NOTE the...
July 24, 2011 at 11:02 pm
Interesting read - thanks for sharing.
I'd be interested also in knowing the cause of the corruption.
Also, you say that you restored your user databases. I am assuming that they were...
May 16, 2011 at 2:03 am
I have just spent close to the last three years working on a project as a dev / admin DBA.
Before we started the project, the whole team - Devs /...
April 28, 2011 at 2:35 am
It's sad to hear this news - I never knew him, but he sounds a great guy.
Just goes to show, what's around the next corner is unknown.
I like your philosophy...
April 25, 2011 at 4:42 am
Not at all. If a person is alive then we know they don't have a date of death at the present time.
Exactly, they don't have a date of death...
April 11, 2011 at 4:07 am
I don't think people who use nulls are crazy. I just think that a database without nulls is a more accurate and usually more practical way to represent information.
but there...
April 11, 2011 at 3:30 am
Hi,
I'm not sure if this post will explain anything that may help you.
cheers
martin.
April 5, 2011 at 5:53 pm
Great question.
One thing that I'd add is that as the unique key will be created as a non-clustered index where as the default for a primary key is to create...
April 5, 2011 at 2:53 am
Good article Steve.
I live in Christchurch, New Zealand and I have to admit that I thought the possibility of losing an entire center here was extremely remote. However recent events...
March 30, 2011 at 10:35 pm
This article appears to have moved. I wonder where it is?
January 16, 2011 at 6:40 pm
Viewing 15 posts - 1 through 15 (of 16 total)