Viewing 15 posts - 1,576 through 1,590 (of 49,571 total)
April 12, 2017 at 2:02 pm
I understand what you are saying, but this is not what is supposed to happen...
April 12, 2017 at 2:01 pm
SQL Server, or Management Studio?
SQL Server will not recreate a table. The closest would be changing the clustered index.
As for Management Studio, easiest answer there is not...
April 12, 2017 at 8:28 am
I don't think there's any T-SQL that worked in 12 and not 16.
What's going to bite you is the cardinality estimator changes. Make sure you test performance of...
April 12, 2017 at 7:34 am
April 12, 2017 at 5:53 am
Grant Fritchey - Thursday, April 6, 2017 12:07 AM1) Completely unnecessary
I strongly disagree. It;s future-proofing code and designs. If the clustered index...
April 6, 2017 at 10:50 am
It's a CLR trigger, common language runtime, written in C#. It's not a T-SQL trigger and that's why you're getting the error when you try to alter it to a...
April 5, 2017 at 6:45 am
Please don't post multiple threads for the same question.
No replies here. Direct replies to https://www.sqlservercentral.com/Forums/1869043/Help-required-for-creating-the-Stored-procedure-for-below-logic
April 5, 2017 at 6:07 am
Don't ever try to put database files or backup files in the root of a drive. Windows protects those locations, especially the root of C
Put it (and the log...
April 5, 2017 at 3:14 am
April 4, 2017 at 3:44 pm
Express12 - Tuesday, April 4, 2017 8:15 AMMy question is, will this work for a table with NO indexes on it?
Yup,...
April 4, 2017 at 8:46 am
I didn't realize there were two versions of AG -- a...
April 4, 2017 at 7:36 am
ThomasRushton - Tuesday, April 4, 2017 3:32 AMJust today to get through before SQLBits. Anyone else from here going to be there?
Yup....
April 4, 2017 at 3:41 am
April 4, 2017 at 3:31 am
Viewing 15 posts - 1,576 through 1,590 (of 49,571 total)