Viewing 15 posts - 2,476 through 2,490 (of 7,502 total)
Can you post the full DDL of your tables ? (object explorer \ rightclick on the table name and script table as create to ...)
This way we can...
January 9, 2011 at 2:45 pm
What's are the primary key columns of the source table and which are the key columns you must use to make sure you are comparing the correct rows.
Once you figure...
January 9, 2011 at 12:52 pm
just a subtle remark.
Make it a unique constraint ! That is implemented with a unique non-clustered index by sqlserver, but will result in everybody knowing it is a constraint and...
January 9, 2011 at 12:00 pm
Chris Kitchen (1/9/2011)
Hi,Thanks for you reply, I never stated that we were restoring the master database every night.
My bad Chris. Sorry for that.
We are planning on using the...
January 9, 2011 at 11:01 am
Mind me asking why you perform the restore of master every night ?
Keep in mind, your instance will not be available to others during your restore ops !
There are other...
January 9, 2011 at 9:33 am
Indeed, warm wine is only good in the sauces grandma makes 😉
With the many flavored gin these days, I prefer doing the gin menu :hehe:
Mainly because I don't like...
January 9, 2011 at 9:19 am
Thank you for correcting that George.
Index tuning wizard is the correct name.:blush:
It can be found in SQLserver Profiler toolbar option "tools".
January 9, 2011 at 3:16 am
Koen (da-zero) (1/9/2011)
ALZDBA (1/8/2011)
Not feeling tip top today.I'll have to refrain from xmas tree burning fest and drink :ermm:
Too much jenever? 😉
Aha, you know the drill :-D:w00t:
January 9, 2011 at 3:09 am
Not feeling tip top today.
I'll have to refrain from xmas tree burning fest and drink :ermm:
:darn:
January 8, 2011 at 12:10 pm
AFAIK there are no missing index info gathered in sql2000.
You'll need to trace for a reference load and have that analysed by database tuning advisor (included in SQL2000).
Then evaluate those...
January 8, 2011 at 12:06 pm
there are log reader tools on the market that can generate undo sql for your transaction.
However, you should also take into account what the impact will be for your system....
January 8, 2011 at 12:02 pm
Seems a familiar request : http://www.sqlservercentral.com/Forums/Topic1044104-148-1.aspx
Someone ( your boss ) is kind of focused on really wanting SSIS 😉
If you build a package that does the flip/flop (switch) operation for...
January 8, 2011 at 10:24 am
Two advantages:
1) the best solution for your company :kiss:
2) the sweet taste of victory for you 😀
ps
don't just make it work, study it so you know how it works.
January 7, 2011 at 12:02 pm
IMO you need to read a little bit on mirroring and the role of a witness ! ( even if it is trivial )
In our typical use cases, we implemented...
January 7, 2011 at 4:12 am
Straight forward, using no rocket science, primitive:
I hope you are already producing sqlserver database backups on a regular basis !
You need to figure out if you want a point...
January 7, 2011 at 12:58 am
Viewing 15 posts - 2,476 through 2,490 (of 7,502 total)