Viewing 15 posts - 1 through 15 (of 666 total)
Why then does SQL Books Online say
OFFLINE Sets the file offline and makes all objects in the filegroup inaccessible.
Or am I misinterpreting that?
August 8, 2020 at 8:58 am
--Solution 1SET DATEFIRST 1DECLARE @d DATE = '2016-05-13 00:00:00.000'--GETDATE()WHILE (@d...
May 8, 2018 at 9:01 am
May 8, 2018 at 8:32 am
Hey, I would have expected a Friday the 13th fun question today. But thanks, learned something.
April 13, 2018 at 3:38 pm
January 15, 2018 at 8:21 am
December 29, 2017 at 4:48 pm
My question remains, why did MS decide to add this useless suffix to the @from_id and @to_id columns? It just makes a joke of the "Explicitly name columns" best practice...
December 21, 2017 at 3:53 pm
December 20, 2017 at 1:12 pm
IF @ID = NULL
IF @ID IS NULL
You cannot compare a value directly to NULL.
December 18, 2017 at 2:09 pm
Junior Galvão - MVP (5/9/2016)
Please check the correct answer!!!
The official Microsoft documentation informs the operation of verifyonly is written in the table.
To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx%5B/quote%5D
May 9, 2016 at 8:49 am
Thanks, Brandie. I found a script on this site (http://www.sqlservercentral.com/scripts/Collation/113863/) that actually takes care of converting all the character and text based columns to a different collation. Quite handy. I...
July 20, 2015 at 5:28 am
Greg Edwards-268690 (7/29/2014)[And Aerosmith is now country, or is that Kenney Chesney is now classic rock?
Aerosmith country? Wow, I must have fallen into hibernation, or American Idol has eventually adopted...
July 29, 2014 at 4:19 pm
Wow, it has been 6 months or so since I last was on this thread. I haven't even been lurking, just too busy to keep up. And no, I'm...
July 29, 2014 at 3:14 pm
Not sure what exactly you want. From the SQL statement you posted it will always insert data for NY and KT if it does not match Fname and Sname, but...
March 17, 2014 at 7:28 am
I think the discussion went a bit off the OP's topic. Yes, he mentioned performance in his last sentence, but basically, the answer has been provided early on. Change the...
March 8, 2014 at 4:17 pm