Viewing 15 posts - 46 through 60 (of 106 total)
Dhruvesh Shah (8/1/2011)
August 1, 2011 at 5:59 am
paul.knibbs (8/1/2011)
SQLkiwi (8/1/2011)
That explains it nicely - and Peter Larsson (SwePeso) added pretty much the exact same example as this QotD in the comments.
It's still realistically a bug, though--even if...
August 1, 2011 at 5:32 am
bitbucket-25253 (6/29/2011)
June 29, 2011 at 5:54 am
Parky_M (6/29/2011)
:unsure: At first I thought I misread the question but after...
June 29, 2011 at 3:01 am
Change is Required (6/28/2011)
SQL Server execution plans have the following main components:
*
Query Plan
...
June 28, 2011 at 8:11 am
This MSDN article gives the same information as the one in the explanation, but also has a word on security--for those who're interested in this topic.
Thanks Steve for another nice...
June 16, 2011 at 6:59 am
Very interesting :w00t:; especially since BOL describes this feature in a way that one may assume it is not possible.
The clue is--and I would say hidden--in this article, where it...
June 8, 2011 at 5:17 am
forsqlserver (5/31/2011)
Please clarify why tempdb is encrypted...Because tempdb is used by all the databases.
I guess this has to do with the following:
When TDE is enabled on any user database, encryption...
May 31, 2011 at 3:44 am
Thanks for the question--educating as always.
You may want to do some more reading on TDE from this MSDN Technical Article.
Regards,
Michael
May 30, 2011 at 5:24 am
Carlo Romagnano (5/26/2011)
Do you mean that for SA you get e.g. 2011-05-26 14:15:37 and for CARLO you get 1900-01-01 02:00:00?
Yes, exactly!
Then I'd assume that CHECK_POLICY has not been enabled for...
May 27, 2011 at 3:05 am
Carlo Romagnano (5/26/2011)
But the strange thing is that for sa the query returns effectively the right date and time, for the user Carlo, despite the settings, no....
May 26, 2011 at 6:53 am
Carlo Romagnano (5/26/2011)
1900-01-01 02:00:00.000
Step 1: bad password attempt
Step 2: correct login
I run the query: SELECT loginproperty('carlo',...
May 26, 2011 at 6:04 am
Tom.Thomson (5/25/2011)
It doesn't use that term, and I'm talking terminology here, not anything else.[...]
And yes, before anyone asks, sometimes I take perfectionism to extremes [...].
Ah, got your point--and understood.
Wish...
May 25, 2011 at 5:45 am
Tom.Thomson (5/25/2011)
But "partition" locks? Surely Heap locks, B-Tree locks (HoBT locks for short)? I don't think the term "partition lock" occurs anywhere in BoL for...
May 25, 2011 at 4:22 am
mohammed moinudheen (5/25/2011)
I referred the link provided in the answer, but couldn't find any information regarding escalation to partition....
May 25, 2011 at 3:04 am
Viewing 15 posts - 46 through 60 (of 106 total)