Viewing 15 posts - 1 through 15 (of 15 total)
Start working on your 2008 R2 cert's. It will look good on a resume and you will learn a lot in the process. Even with out experience you can put...
June 16, 2010 at 1:33 pm
No, you have to allocate drives to that instance.
June 2, 2010 at 10:00 am
What are you trying to accomplish? Is this for DR, high availability or some other reason?
And how much space do you think you will need? Sorry for all the...
June 1, 2010 at 2:49 pm
Nice question. I almost got it wrong because when I read it, I assumed the output had a "into @myTable" after it. But when I read it again (and actually...
May 19, 2010 at 12:44 pm
All kidding aside, log shipping is going to be your easiest and cheapest route to go. Set it up a week or two in advance. Then when you are ready...
May 14, 2010 at 9:21 am
For what you are doing, log shipping sounds like a good solutions. It will take a little time to get it setup, but once it is, you should not have...
May 13, 2010 at 3:06 pm
How about using Business Intelligence in SQL Server. It is a pretty interesting topic (at least it is to me, but then again, I am a nerd) and I know...
May 13, 2010 at 8:41 am
Using your insert code, lets look at K9ID 3, just to make it simple.
How many rows are you expecting to get back? For Dose 100, which record are you...
May 12, 2010 at 3:17 pm
One thing you did not mention was BI. This is becoming very important for a lot of businesses. In 2008 and R2, BI is a very big deal. Get a...
May 6, 2010 at 11:19 am
Robert Davis (4/24/2010)
That's a bad, bad idea.
Just my 2 cents, but when Robert Davis, the guy that wrote the book on what you are trying to do, says it is...
April 26, 2010 at 10:10 pm
Based off what you said above, I would say consider clustering for HA and log shipping to a remote site for DR.
Clustering will be invisible to the app and...
April 23, 2010 at 11:55 am
We use clustering and log shipping to a remote site. This has worked very well for us and both are pretty straight forward to setup and maintain.
But in the...
April 22, 2010 at 7:40 am
The way to remove a second log file is to ensure that the active log is only in the other log file and then drop the file. Remember the log...
February 9, 2010 at 9:30 am
The problem is the new table is going to dynamic. I should have explained better in the OP.
I am making a stored procedure that will backup procedures, views, functions...
July 11, 2008 at 9:00 am
Viewing 15 posts - 1 through 15 (of 15 total)