Viewing 15 posts - 6,091 through 6,105 (of 8,416 total)
jcrawf02 (2/18/2010)
That's not entirely true though, if you SET IDENTITY_INSERT ON, you can force identity values that are out of sequence:
Interesting point - thanks for sharing.
February 18, 2010 at 10:05 am
Oh for the sake of small fluffy bunnies!!!!
I've blanked my post - can I get on with my life now?
Thanks
:w00t:
February 18, 2010 at 10:01 am
Alvin Ramard (2/18/2010)
ALTER TABLE SET LegNo2.LENGTH = LegNo2.LENGTH * 1.01🙂
Someone keeps running that on my dining room table - I keep stuffing napkins and such under one shorter leg, but...
February 18, 2010 at 9:59 am
@TSG*
We are getting paid for this...right?
LOL
*The SQL Guru
February 18, 2010 at 9:57 am
CirquedeSQLeil (2/18/2010)
What was that Gail, you were coming in a bit fuzzy.
There was also an echo...
February 18, 2010 at 9:54 am
Bru Medishetty (2/18/2010)
george sibbald (2/18/2010)
without compression database snapshots comes into the frame much more.George, correct me if I understood you wrong, are you suggesting database snapshots in the above statement?
I...
February 18, 2010 at 9:53 am
george sibbald (2/18/2010)
Paul White (2/18/2010)
The overall size of the database is not that important.Paul
might affect whether simple backup\restore is viable and the initiation of log shipping.
Yes George, I know. ...
February 18, 2010 at 9:51 am
Jack Corbett (2/18/2010)
Paul White (2/18/2010)
Grant Fritchey (2/18/2010)
February 18, 2010 at 9:45 am
Ok I see your point.
I can't promise I wouldn't reply in the same vein again, but I'll bear your comments in mind.
Cheers
Paul
February 18, 2010 at 7:25 am
luckysql.kinda (2/18/2010)
How system_seeks, system_scans and system_lookups are different in sys.dm_db_index_usage_stats? This will inform me which index is least used and I shall think about removing that.-Lk
Shouldn't you be looking at...
February 18, 2010 at 7:21 am
Barry,
No, I think you're going to have to jump through some hoops on this one, and it may not be pretty.
That's just my recollection - it's been a while since...
February 18, 2010 at 7:10 am
Just to add a small thing to Carolyn's reply: you can customize the scripting output you get.
In SSMS go to Tools, then Options.
In the window that appears, navigate to SQL...
February 18, 2010 at 7:06 am
How up-to-date must the reporting database be?
Do you already have database backups (full/diff/log) available at the report server site?
Is the report server at a different site?
How fast is the link?
And...
February 18, 2010 at 7:03 am
Books Online (hit F1) to the rescue!
sp_change_log_shipping_primary_database
sp_change_log_shipping_secondary_database
See the @threshold_alert and threshold_alert_enabled parameters in particular.
Paul
February 18, 2010 at 6:59 am
You could consider log-shipping, mirroring with a database snapshot over the secondary, or a backup/restore, possibly using the COPY_ONLY option. It depends on your requirements and which edition of...
February 18, 2010 at 6:53 am
Viewing 15 posts - 6,091 through 6,105 (of 8,416 total)