Viewing 15 posts - 31 through 45 (of 476 total)
We monitor the size of TLog backup files - as an indicator of any database that is having way more TLog activity than normal and, indeed, if an individual backup...
February 25, 2021 at 5:39 am
We store all Sprocs in individual files (with a folder structure for Project / Client / whatever)
If I want to modify an Sproc I just open the file, work on...
February 24, 2021 at 1:47 pm
Except - you have to execute SQLCMD from *something*.
Haven't you got to run a PowerShell Script from "something"? (Ignorant question as I have only ever used PowerShell from...
February 24, 2021 at 9:53 am
Longshot: Report is pulling the resultset row-by-row, rather than "bulk"
February 24, 2021 at 8:50 am
Could you add to the conclusion the time it would take to have done the migration without log shipping?
It took us 30 minutes (versus X minutes)
Good point. The reverse...
February 23, 2021 at 12:55 pm
Setting up / tearing down log shipping just for a one-time move seems like a lot of overhead to me
Instead of logshipping, these were my steps:
February 23, 2021 at 11:41 am
Can you do it in one statement?
SELECT@TheDetails = CONCAT('The Following Items Have Changed:'
, CASE WHEN ValueA <> ValueB THEN ' Some more stuff' ELSE '' END
, CASE... February 23, 2021 at 6:34 am
First I tried the PowerShell ISE route by saving my query to a file ...
I'm not a fan of PowerShell. I use it very infrequently, and as a consequence...
February 23, 2021 at 6:22 am
My answer is, of course, "It Depends" ...
Indeed, and that's fair enough. But my current method may not be the smartest way (and having done it "my way" for...
February 23, 2021 at 5:08 am
In this instance using ... varchar without a length works as well, but we really shouldn't get into that bad habit.
Definitely a bad habit 🙂 ... the resulting data...
February 22, 2021 at 12:41 pm
If the question is wrong, how do you even pick an answer?!?
I must be missing something because I cannot find fault with the question:
How can I get this in...
February 22, 2021 at 12:18 pm
Try and read the Transaction Logs to see what happened.
Unless someone knows of an easy way I reckon that is "very hard" to do, in practice
Start trace in SQL Server profiler...
February 22, 2021 at 11:39 am
Doesn't anyone review these questions before they are published?
Surely the point of questions like these is to deliberately raise issues that make people think and try things out and...
February 22, 2021 at 11:29 am
I have copied the DATA folder from that other machine running SQL server to the desktop of my home machine.
I reckon your best bet would be to take a...
February 22, 2021 at 5:23 am
DECLARE @d DATETIME = '2021/02/22'
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a varchar data type to a datetime data type resulted in an...
February 22, 2021 at 5:20 am
Viewing 15 posts - 31 through 45 (of 476 total)