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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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.
Thanks again - I'll...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
March 18, 2020 at 10:47 am
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 rather than...
Thomas Rushton
blog: https://thelonedba.wordpress.com
March 18, 2020 at 9:53 am
Closing this as it's a duplicate of https://qa.sqlservercentral.com/forums/topic/optimise-speedup-query
Thomas Rushton
blog: https://thelonedba.wordpress.com
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?
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
March 10, 2020 at 9:36 am
Hi
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
February 5, 2020 at 1:28 pm
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
February 5, 2020 at 1:23 pm
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 need coffee. ...
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 31, 2020 at 8:44 am
Viewing 15 posts - 1 through 15 (of 984 total)