Viewing 15 posts - 1,291 through 1,305 (of 1,584 total)
GilaMonster (12/2/2011)
MyDoggieJessie (12/2/2011)
December 2, 2011 at 10:46 am
One more thought: while I am redoing this for the broken DB, should I blow away the current log shipping setup for the database? If I don't the...
December 2, 2011 at 10:43 am
Thanks for the replies everyone...this is what I thought :crazy:
So I'll have to copy up and then restore the latest full backup to the secondary server (which will take about...
December 2, 2011 at 10:40 am
Yes there is ample space.
That's what I was afraid of...having to restore from a full backup and basically starting over with logshipping from that database...can I restore just...
December 2, 2011 at 10:03 am
I'm with Jared. Clearly a permissions problem but am out of ideas :crazy:
December 1, 2011 at 1:03 pm
Wow....4 posts hit this before I was able to post mine...I must be typing too slowly today!!!
December 1, 2011 at 10:30 am
You shouldn't change the size of your LDF files. Typically you set your LDF file to a specific size to begin with to allow for rapid/sudden data movements/transactions and...
December 1, 2011 at 10:29 am
It depends.
Normalization is one of those things you want to have in a RDMS but can be its design can overkill if you don't anticipate or you know for certain...
December 1, 2011 at 9:48 am
No..I am not able to access any linked server unless I create the linked server connection directly on sql server installed on my laptop.
I am getting a little confused....
December 1, 2011 at 9:35 am
Lowell, I have no doubt that the origination of the SQL I posted was derived from this website 🙂
November 30, 2011 at 2:35 pm
Where WHILE loops benefit the most over cursors is being able process a batch of records in each iteration versus cursors only allowing one record per iteration. But since the...
November 30, 2011 at 2:33 pm
Awesome, glad I was able to help. The HTML output is nice for audits too 🙂
November 30, 2011 at 1:56 pm
Sorry if I asked this already...but what's the version of your laptop SQL running? And are all 3 OS's 32-bit? I don't suppose your laptop is running 64-bit is...
November 30, 2011 at 1:36 pm
Try this link
In the first article you should see a list of all the current DMV's broken down by category
All joking aside, you can use this TSQL (snagged from my...
November 30, 2011 at 1:34 pm
What is best to rewrite the below query instead of using temp table or cursors
Do you have specific concerns with using the temp tables? Or are you seeing some...
November 30, 2011 at 1:10 pm
Viewing 15 posts - 1,291 through 1,305 (of 1,584 total)