Viewing 15 posts - 811 through 825 (of 1,319 total)
VEB (1/29/2009)
First, all the applications will be on the same domain as the system with SQL Server is. So only Windows Authentication will be used.
Second,...
-- You can't be late until you show up.
January 29, 2009 at 7:53 am
Renuka (1/27/2009)
Using arguments like (REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD), the CHECKDB errors can be repaired. (Check BOL for more info. as these options need to be used catiously. There may be...
-- You can't be late until you show up.
January 29, 2009 at 7:36 am
I don't know if I'm considered a regular or not. I am on the site daily but not always posting - some days simply perusing the new posts, picking up...
-- You can't be late until you show up.
January 28, 2009 at 7:57 am
Adam McArdle (1/28/2009)
tosscrosby (1/26/2009)
Something like:???insert into temp2_sales
select * from temp_sales
where temp_sales.product_number = 0
and temp_sales.customer_number not in (SELECT customer_ID from temp2_sales)
Almost, you missed out a SELECT, see...
-- You can't be late until you show up.
January 28, 2009 at 7:36 am
Woo-Hoo - 1,000,352 as of this post.
-- You can't be late until you show up.
January 28, 2009 at 7:32 am
Steve Jones - Editor (1/27/2009)
We're donating some rainforest, purchasing 1mm sq ft of rainforest as a celebration. That's a...
-- You can't be late until you show up.
January 27, 2009 at 3:02 pm
And just to add to your reading pleasure, Paul Randal wrote this article. It may give you a little better understanding of recovery. Not necessarily what is right for your...
-- You can't be late until you show up.
January 27, 2009 at 1:47 pm
Something like:???
insert into temp2_sales
select * from temp_sales
where temp_sales.product_number = 0
and temp_sales.customer_number not in (customer_ID from temp2_sales)
-- You can't be late until you show up.
January 26, 2009 at 2:01 pm
tosscrosby (1/26/2009)
rew (1/26/2009)
All depends on business needs
The frequency is dependent on business needs. Hourly is good but does it meet your needs???
-- You can't be late until you show up.
January 26, 2009 at 11:40 am
rew (1/26/2009)
1) with 10, it somehow changes back to "By Percent" with 10% !!!Is this a bug or is there someone else changing the parameter?
Not a bug that I've...
-- You can't be late until you show up.
January 26, 2009 at 10:03 am
I found this by Paul Randal, I believe in yesterday's daily newsletter.
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
This is on Gail's website:
http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
A lot of responses to a question like this is the infamous "it depends". You...
-- You can't be late until you show up.
January 23, 2009 at 3:28 pm
We use Tigerzip. The data they provided us has latitudes and longitudes so that when a user plugs in a zip code they can also choose a distance from the...
-- You can't be late until you show up.
January 22, 2009 at 12:57 pm
Ninja's_RGR'us (1/21/2009)
... or the work break has just stared :P.
Mine just "stared".....;)
-- You can't be late until you show up.
January 21, 2009 at 6:13 am
Mike John (1/19/2009)
DBCC SHOINKDATABASEMike John
New in SQL 2005???? 😛
-- You can't be late until you show up.
January 19, 2009 at 9:06 am
Not if the database that was backed up contained one mdf file. If it had a mdf and a ndf, each under 1.5Gb, you could do it but not if...
-- You can't be late until you show up.
January 15, 2009 at 3:13 pm
Viewing 15 posts - 811 through 825 (of 1,319 total)