Viewing 9 posts - 1 through 9 (of 9 total)
Steve Jones - SSC Editor (4/7/2015)
It's a work tracking item that I have. As I work, I move these through the status areas (queue, working, done). If I need to...
April 7, 2015 at 1:11 pm
One thing to consider is that if you turn on the configuration option "optimize for ad hoc workloads" none of these different queries get cached as ad-hoc plans, so the...
February 18, 2015 at 5:53 pm
jan.heimdal (2/4/2015)This seems simpler to me:DELETE --or SELECT *FROM #DuplicateRowWHERE JobTitle = 'Editor' and datemodified < (SELECT MAX(datemodified) FROM #DuplicateRow WHERE JobTitle = 'Editor')
DELETE --or SELECT *
WHERE JobTitle = 'Editor' and datemodified < (SELECT MAX(datemodified) FROM #DuplicateRow WHERE JobTitle = 'Editor')
Hmm, I'm agreeing more with...
February 4, 2015 at 5:51 pm
As for the endpoint configuration I can confirm that yes, endpoints are created with the principal_id of the login creating them; we had a situation where a person left...
May 14, 2014 at 10:55 am
Chiming in with my $0.02 here ...
I have had experience with developers wanting to use GUIDs as PKs, and my argument against is very simple - the intent of a...
October 12, 2010 at 11:13 am
Tom Garth (7/15/2010)
Chris Stewart-397033 (7/15/2010)
Indicates that the new column is an identity column....
July 15, 2010 at 10:22 am
Also in BOL under the CREATE TABLE entry is the following (partial) definition of IDENTITY (emphasis mine):
Indicates that the new column is an identity column. When a new row...
July 15, 2010 at 9:39 am
An unusual situation occurred for me. The first time I ran the SELECT statement the plan was a Clustered Index Scan. Subsequent runs were the expected NC Index...
May 5, 2010 at 11:59 am
Actually, disabling a nonclustered index deletes the physical index; only the definition is retained. Per BOL:
"The index definition of a disabled index remains in the system catalog with no...
July 21, 2008 at 10:46 pm