Viewing 15 posts - 5,626 through 5,640 (of 7,483 total)
eccentricDBA (8/11/2011)
Tom and Jerry
Ok, I'm here. Where's Jerry? :w00t:
Tom
August 11, 2011 at 9:53 am
Brandie Tarvin (8/11/2011)
Is it just me, are am I being particularly unhelpful this morning?http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx
No, you are not.:-)
It's just that the posted questions really are getting worse. 😉
Tom
August 11, 2011 at 9:45 am
Revenant (8/10/2011)
I was told that this will be “soon”...
Tom
August 11, 2011 at 9:38 am
Lynn Pettis (8/10/2011)
My only concern would be if any of the tables contained columns defined as text or ntext.
Well spotted, Lynn! if there are such columns spotting duplicates is...
Tom
August 10, 2011 at 9:31 pm
Good question.
I thought about it for a while - and remembered previous discussions on SQLCentral about what a total disaster shrink is (unless you immediately follow it be reubuilding everything...
Tom
August 10, 2011 at 8:57 pm
Good question.
I find this compression behaviour for heaps quite amazing - I guess heaps really are second class citizens these days.
Tom
August 10, 2011 at 8:39 pm
ALTER Database COLLATE <collation_name>
That will alter the default collation for the database. It will NOT alter the collation of any existing columns in tables. You'll have to alter...
Tom
August 10, 2011 at 8:16 pm
It's very easy to construct an SQL string containing the column list from system views and execute it.
For example, if your database were called "playpen" this stored procedure...
Tom
August 10, 2011 at 8:10 pm
vasu_kaladi (8/1/2011)
I would like some more explanation on how the original table you started...
Tom
August 10, 2011 at 4:37 pm
Revenant (8/10/2011)
Tom.Thomson (8/10/2011)
Not in most countries except Britain (note single t), in all countries including Britain. Datetime2 uses the Gregorian calendar, not any other calendar, so it...
Tom
August 10, 2011 at 4:08 pm
Are the rows that get deleted but shouldn't in prospects or in prospectincampaigns or are there wrongly deleted rows in both? Does the wrong delete happen when @campid is...
Tom
August 10, 2011 at 11:04 am
petervdkerk (8/10/2011)
Tom
August 10, 2011 at 10:18 am
hakan.winther (8/10/2011)
I expected it to work and it did ( as it should in most countries except in brittain ) 🙁
Not in most countries except Britain (note single t), in...
Tom
August 10, 2011 at 9:42 am
Ninja's_RGR'us (8/10/2011)
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
Not on my first read. I'd want to protect SA as...
Tom
August 10, 2011 at 9:35 am
Viewing 15 posts - 5,626 through 5,640 (of 7,483 total)