Viewing 15 posts - 1 through 15 (of 496 total)
@joe Celko
Wow Joe, thanks for the thorough treatise!
In answer: The original table does have a key, I omitted it as part of the simplification...
March 1, 2018 at 1:02 pm
@luis Cazares
Thanks for this simplification - I have several of these reports to do, and this will help me get back into the SQL mindset.
February 28, 2018 at 7:53 am
OK so preparing this data for SSC seems to have stimuated a few grey cells
I've fixed the output it - as follows
However - can it be...
February 28, 2018 at 7:36 am
Yes it turns out that auto create statistics, and auto update statistics are off. I know our DBA runs a daily job to update stats, but obviously that won't do...
April 6, 2017 at 1:09 am
Am I out of date? I am the only one who missing something here?
Msg 102, Level 15, State 1, Procedure MyProc, Line 32
Incorrect syntax near 'THROW'.
Msg 2812, Level 16, State...
May 27, 2015 at 2:07 am
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
Definitely (A)
For sure advertise your own...
May 14, 2015 at 6:28 am
Thanks John,
Brilliant lateral thinking.
October 22, 2014 at 5:18 am
Technology changes so quickly - for a career in IT you will learn stuff that will be obsolete in 5 years. You will learn stuff you will never use...
July 22, 2014 at 12:20 pm
Go here:
http://www.microsoft.com/en-gb/download/details.aspx?id=29062
download and install this file:
ENU\x64\SQLEXPRWT_x64_ENU.exe this one is With Tools (i.e. includes SSMS - SQL Server Management Studio). I don't think you will need the advanced tools...
July 21, 2014 at 4:53 pm
Is there a reason something like this wouldn't work?
CREATE TRIGGER CheckReportsFinished ON dbo.ReportStatus
AFTER INSERT
AS
DECLARE @COMPLETEDROWS INT = 0
SELECT @COMPLETEDROWS = COUNT(*) FROM dbo.ReportStatus WHERE [success flag] is not null;
IF (@COMPLETEDROWS...
July 8, 2014 at 7:23 am
This uses DiskPart.exe, which may give the information you need - I tried this in powershell and it did tell me the online/offline status of local disks. Not sure...
July 8, 2014 at 6:38 am
Well our current DBA has been referred to (and I quote) as "slash dev slash null" - (which seems to have multiple meanings ) - but the one in point...
April 21, 2014 at 11:50 am
Thanks
I must be getting old because I've used OPENROWSET before in other projects, and didn't remember at all when posting this question.
However on this particular project they don't like linked...
April 15, 2014 at 7:04 am
I recently heard the phrase "the guy is like so /dev/null" (referring to a SysAdmin, but it could be anyone who you need to do something for you for a...
April 7, 2014 at 4:29 am
Hi
I was interested in your question, and did a bit of research. - However I don't think there is a way to access the timezone offsets from within SQL Server,...
February 20, 2014 at 10:09 am
Viewing 15 posts - 1 through 15 (of 496 total)