Viewing 15 posts - 256 through 270 (of 1,271 total)
The table variable was just to deo the code. Where do you have the data stored?
June 25, 2012 at 11:45 pm
So obviously, I was mistaken. you can find a description of how to do it here: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/4989cdb8-bb69-46a4-865a-2deecd20ddf4
June 25, 2012 at 10:56 pm
Use the SUBSTRING() function and CHARINDEX() function.
Syntax: SUBSTRING(<Expression>, <Start position>, <Length of string>)
Expression is the string.
Start position = use Charindex to identify the point where to start the substring
Length of...
June 25, 2012 at 10:38 pm
We told Brent about that bug in the script last week. He said he'd look at it as soon as he could. that line you mentioned should be <- instead...
June 25, 2012 at 10:06 pm
It can't be clustered and a member of an AlwaysOn Availability Group. It has to be one or the other.
June 25, 2012 at 10:02 pm
1. Create an Extended Events session to capture execution information regarding sp_start_job.
2. It doesn't get moved. They are both updated individually.
June 25, 2012 at 8:05 am
The script I posted pre-dates PowerShell. If I were to write it today, i would use PowerShell and SMO.
June 24, 2012 at 7:51 pm
Not very relevant any more, and I'm only posting it as a bit of trivia, but there is also a default path for full-text catalogs there.
I wrote a script years...
June 24, 2012 at 6:51 pm
Ted_Kert (6/23/2012)
Intent locks improve performance by putting a lock that could be escalated on a table or row. How does it improve performance?
They increase the chance that it will...
June 23, 2012 at 3:19 pm
Short answer:
Save the backup file...
June 23, 2012 at 3:00 pm
How much it changes depends on the activity of your server. If you haven't generated enough transactions to fill up the current virtual log file (VLF) and move on to...
June 23, 2012 at 2:50 pm
Do you get this error everytime you run it on that database or just the one time? What edition of SQL? If using Enterprise Edition, can you create a snapshot...
June 22, 2012 at 9:37 pm
You should be aware that the registry xp's are undocumented and subject to change at any time as are the paths of the values int eh registry. You can get...
June 22, 2012 at 9:30 pm
Were you taking log backups with NoRecovery?
June 22, 2012 at 9:22 pm
Viewing 15 posts - 256 through 270 (of 1,271 total)