Viewing 15 posts - 1 through 15 (of 498 total)
Yes probably the DBA's subtle way of getting me to learn about replication, or to leave it well alone.
And at least it was only the dev environment.
Thanks for your help...
September 26, 2022 at 5:08 pm
As to why .. I deleted some rows from the publisher first - then noticed the delete did not happen in the subscriber - so then I deleted from the...
September 26, 2022 at 4:20 pm
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 CazaresThanks 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!!!
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!!!
For sure advertise your own...
May 14, 2015 at 6:28 am
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
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
DECLARE @COMPLETEDROWS INT = 0
SELECT @COMPLETEDROWS = COUNT(*) FROM dbo.ReportStatus WHERE [success flag] is not null;
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
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