Viewing 15 posts - 496 through 510 (of 8,760 total)
Just noticed this when I was putting this on a new instance, but in the .sql file the WITH starts with a leading ;, which actually breaks the DDL...
March 30, 2020 at 6:21 pm
Comments posted to this topic are about the item SQL Is Always Going to be Popular
Reminds me of your April's Fools' day Linux post a few years back...
March 18, 2020 at 7:26 pm
Her being home isn't helping because she's also one of those folks that has to say everything she's doing out-loud as she's doing it. It's as...
March 18, 2020 at 5:50 pm
this isn't a HP laptop is it? we've had a few where bios wasn't detecting the battery. - quick bios update and BOOM it all works. however... factory...
March 18, 2020 at 4:27 pm
I don't know about anyone else, but if the virus doesn't get me, staying home with these kids for weeks certainly will!
How are you my friend and how are...
March 17, 2020 at 6:12 pm
may we ask the reason for downgrading ? - could it be something settled by a compatibility mode setting?
as far as I can see - a downgrade is a...
March 17, 2020 at 3:20 pm
Therefore not sure what the documentation is really getting at.
The INFORMATION_SCHEMA is of course a "compatibility" schema, hence the warning in the documentation 😉
😎
March 12, 2020 at 4:11 pm
There is no difference really, both use the internal system tables, haven't found any difference between the output of the two.
😎
A simple way to visualize the difference would be running...
March 12, 2020 at 2:51 pm
Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?
Last time I worked on it, it was...
March 11, 2020 at 8:33 pm
Jeff, are you starting an #XM(e)L2 tag 😉
😎
Handling such simple data sets is elementary, done quite few more complex doing 10-20K transactions / second
First suggestion, normalize the data, i.e.:
March 11, 2020 at 6:32 pm
We have a group who's sole responsibility is to write reports. They are supposed to be doing data analysis, but that's another subject.
None of them have any technical skills,...
March 6, 2020 at 2:39 pm
don't - I went once and it was "an experience" (this is from Wikipedia)
Kæstur hákarl, fermented Greenland shark.
Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and cured...
March 2, 2020 at 4:36 pm
Glad to see everyone is talking about SQL Server stuff. Hope you've had a good last month.
The end of last month was fantastic because I had a week...
March 2, 2020 at 4:00 pm
Glad to see everyone is talking about SQL Server stuff. Hope you've had a good last month.
the last 30.4375 days? 😉
😎
February 26, 2020 at 7:11 pm
Just for fun, this can be done with four functions
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @string varchar(1024) = 'Total # of bytes : 128270200832 (119.46GB)';
;WITH NO_SPACE AS
(
...
February 18, 2020 at 1:36 pm
Viewing 15 posts - 496 through 510 (of 8,760 total)