Forum Replies Created
Viewing 15 posts - 46 through 60 (of 9,244 total)
-
Reply To: Tablock to avoid deadlock
transactions should be as short as possible, performing lookup work mid transaction will always cause concurrency issues.
What makes you think locking the whole table is better when a row or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: backup file name null in msdb..backupset table
Jason A. Long wrote:Snargables wrote:disregard. i found it. I'll reply w/ what i end up with to close the loop
Did you ever find the solution? If so, would you be kind enough...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: What component of I/O subsystem caused database corruption
try working with your storage admins firstly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Backup of encrypted databases failing
Emperor100 wrote:You can try updating the master key on DEV server by restoring the Master Key on DEV from PROD:
No! Definitely dont do this, besides the fact you shouldnt restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Unable to connect to SQL Server '(local),1433'
Casper101 wrote:Agent log has the following 4 entries at the time of failure:
[298] SQLServer Error: 26, Client unable to establish connection because an error was encountered during handshakes before login....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Unable to connect to SQL Server '(local),1433'
whats in the sql log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Error: Server is configured for Integrated authentication only.
have you double checked the auth type on the instance to ensure it's still mixed mode.
If someone changed it and then a restart occurred down the line the new auth...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Script
heres some code you may find useful
http://blog.perrywhittle.co.uk/post/2024/06/25/Restore-database-code.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Script
I have a script depending on exactly what you need to do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Script
Not clear what you require, if you backup dbs to shared drive and want to restore from there why do you want to change the path.
Do you mean you want...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: indexes cleanup
32 vcpu is excessive on any vm, at the very least the host cpu scheduler will have hard time scheduling the vcpus unless you’ve been smart with vm placement
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Are the posted questions getting worse?
Neil Burton wrote:You should start a thread about that 😉
Phil Parkin wrote:Bravo, Neil!
Grant Fritchey wrote:Oooh, that's a good idea.
Steve Jones - SSC Editor wrote:
ah right so Comedy Central not sql server central.
if I were...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Removing Filestream - How?
Steve Jones - SSC Editor wrote:that's incorrect. It's not links to files. It's streamed a file into a hidden/inaccessable place in the file system that can be read back from t-sql and a win32...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Removing Filestream - How?
Steve Jones - SSC Editor wrote:We've given you straight answers, but I don't think you understand Filestream, so they don't make sense. You have to invest a bit to understand how this works to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: indexes cleanup
Stats are more important that index maint, indexes in sql server are fairly robust as long as the stats are good
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 46 through 60 (of 9,244 total)