Viewing 15 posts - 5,626 through 5,640 (of 7,484 total)
SanDroid (8/11/2011)
UMG Developer (3/12/2011)
Years later and the question is still broken... 😉
Yes it is. You have to wonder where was Steve? He has stepped in for questions that were...
August 11, 2011 at 3:55 pm
eccentricDBA (8/11/2011)
Tom and Jerry
Ok, I'm here. Where's Jerry? :w00t:
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. 😉
August 11, 2011 at 9:45 am
Revenant (8/10/2011)
I was told that this will be “soon”...
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...
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...
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.
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...
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...
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...
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...
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...
August 10, 2011 at 11:04 am
petervdkerk (8/10/2011)
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...
August 10, 2011 at 9:42 am
Viewing 15 posts - 5,626 through 5,640 (of 7,484 total)