Viewing 15 posts - 1 through 15 (of 19 total)
Peter Brinkhaus (4/28/2010)
Here's another parameterized version. Thanks to Quatrei.X for the test script.
...
Peter, your solution is brilliant! You're a d**n genius! It saved my day - thanks for your contribution!...
March 28, 2014 at 1:30 am
Jeff Moden (3/4/2013)
...they answer with the same wrong answer, that you have either a faker or a poser on your hands ...
Brilliant! Never seen it that way - gives the...
March 4, 2013 at 11:21 pm
Answer 7 is misleading, isn't it?
7) A clustered index is the index of the physical order of the rows of the table on disk.
It's just the logical order -...
March 4, 2013 at 1:58 am
Great Topic!
We're already collecting data such as:
-Backup Health
-Service Status
-Fixed Drives Space
-File Space Usage (Data, Index, Unlocated, ...)
-Files Events (Grows, Shrinks, ...)
-Failed Jobs
-Unusual Log Entries
-Schema Change Events
-Server Configuration Changes
Wait Stats...
November 19, 2012 at 4:46 am
What is I use 'YYYY-MM-DD'?
I can't promise 'YYYY-MM-DD' will work regardless of your current settings.
'YYYYMMDD' does always work. Just stick to this little rule, it doesn't hurt and you won't...
July 11, 2012 at 11:25 pm
By the way, please don't use date literals like this:
'MM/DD/YY'
This might will not work on system which use other language settings (or datetime settings) than english.
Please always use the ISO...
July 11, 2012 at 12:05 am
GilaMonster (7/4/2012)
For seeking, for range scans, for supporting an order by.
Oh, I didn't have the ORDER BY clause in mind yet. Thanks, it's more clearly now.
So, if I my query...
July 4, 2012 at 2:05 am
GilaMonster (7/3/2012)
Any time at all that you query the index's order is irrelevant. Join or no join.
Hmm, when is the index's order relevant? I can create an index in ASC...
July 3, 2012 at 11:38 pm
GilaMonster (7/3/2012)
No. They define the logical order only.
Interesting! I'm in the business since five years - and all the time I've been wrong!:w00t:
Thanks!
July 3, 2012 at 7:02 am
Clustered indexes define the logical order of the table
I would say: Clustered indexes define the physical order of the table. Am I right?
July 3, 2012 at 4:34 am
Good thoughts! Go ahead and create a "Connect Item"! 😀
I will vote for it.
October 21, 2011 at 2:39 am
SQL Kiwi (9/28/2011)
... When I really need to see attributes, I use the sys.dm_exec_plan_attributes DMV. ...
sys.dm_exec_plan_attributes is interesting!
But the whole story seems to be just a SSMS-Bug in...
September 28, 2011 at 10:10 am
Jack Corbett (9/27/2011)
... the results are being returned according the active setting, not by what's reported in the execution plan.
Yes, you're right Jack - I can confirm on my machine...
September 27, 2011 at 11:38 pm
The preferred LOB (Large OBject) types in SQL Server are ...
Preferred by whom? You can also use varbinary(max):
March 11, 2011 at 12:34 am
Viewing 15 posts - 1 through 15 (of 19 total)