Viewing 15 posts - 1 through 15 (of 984 total)
The idea of doing a DROP & CREATE fills me with dread - all the bespoke permissions you could lose...
May 1, 2020 at 9:35 am
There's a product over here that claims to kill 99% or so of bacteria and viruses and I've always thought it's the 1% we need to worry about that...
May 1, 2020 at 9:31 am
Following on from John's comments, above, you can see if you are using any of those enterprise-only features by spinning up an instance of SQL Server 2019 enterprise edition (or...
April 30, 2020 at 10:17 am
Actually, Allstate has a Belfast office and we do remote for IT workers.And right now, everyone is doing remote. We are well equipped for remote work.
Actually, Allstate has a Belfast office and we do remote for IT workers.
And right now, everyone is doing remote. We are well equipped for remote work.
Thanks again - I'll...
March 18, 2020 at 1:47 pm
Now you've gone and done it - I need to boil my laptop now.
In keeping with the tenor of the times, I'm just throwing mine away...
March 18, 2020 at 10:47 am
In keeping with the tenor of the times, I'm just throwing mine away rather than...
March 18, 2020 at 9:53 am
Closing this as it's a duplicate of https://www.sqlservercentral.com/forums/topic/optimise-speedup-query
March 10, 2020 at 3:55 pm
Out of interest, but I think it might be related... have you got any power management settings configured on that server?
March 10, 2020 at 3:53 pm
From the post:
Not sure where this is useful or why it's there, but if anyone uses this, let us know.
If you yabingle "quirky update", you'll find examples of its use...
March 10, 2020 at 9:36 am
I use a DB that is used mainly for creating views and tables for another "data" db.
A table has changed and I need to find all the Stored Procs...
February 24, 2020 at 4:48 pm
this makes me shudder, (don't do this unless under adult supervision) - I've had to occasionally swap the DB to simple mode, checkpoint it, shrink the log (purely for...
February 24, 2020 at 9:48 am
Where is the BCP file created?
I note that you are running the sp_configure xpcmdshell statement after you've attempted to run xp_cmdshell for the first time; I also note that your...
February 12, 2020 at 9:47 am
Tonight, I'll be having haggis. Pray for me.
Tonight, I'll be in a theatre orchestra pit for the 5th time this week. No need for prayers - I...
February 5, 2020 at 1:28 pm
February 5, 2020 at 1:23 pm
Tonight, I'll be in a theatre orchestra pit for the 5th time this week. No need for prayers - I need coffee. ...
January 31, 2020 at 8:44 am