Viewing 15 posts - 1,801 through 1,815 (of 7,502 total)
side note on DBCC DBREINDEX in books online :
Important:
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development...
August 1, 2011 at 12:56 am
my car consumes 9L/100km.
Is that good ?
Maybe, maybe not.
That depends on the kind of car, track, payload,...
What I mean is, without the query, table structure, available indexes, number of rows...
July 31, 2011 at 11:51 pm
GilaMonster (7/31/2011)
July 31, 2011 at 12:41 pm
- Online only works with EntEdtn / Devedtn / eval edtn ( and not in all cases ... see bol)
- couple of guidelines in msdn: http://msdn.microsoft.com/en-us/library/ms189858.aspx
- bol:http://msdn.microsoft.com/en-us/library/ms188388.aspx
How it works:...
July 31, 2011 at 12:26 pm
Here are two little articles that can help you throwing some light on your log "problem".
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
If you still want to proceed with your current handling after reading these, you just...
July 30, 2011 at 7:23 am
0
Please elaborate as Gail requested.
July 30, 2011 at 7:14 am
Gianluca Sartori (7/30/2011)
Jeff Moden (7/29/2011)
Gianluca Sartori (7/29/2011)
I'm inaugurating my "Vote for Jeff" signature. 😎
BWAA-HAAAA!!!! VERY cool, Gianluca. And, Uncle Sam is my favorite patriotic character to boot!
The only...
July 30, 2011 at 3:10 am
you may also want to add your purge script, used every 16h to let us have a look how you are trying to do it.
July 28, 2011 at 8:57 am
How about just recording key data with a trigger to a staging table, then have a sqlagent job launch your SSIS job through an alert ?
Have a look at http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
July 28, 2011 at 5:50 am
Nice tests Gianluca !
However, regarding the performance impact for this quest compared to a trigger should be the same.
(b)locking will be part of the game with either solution, so support...
July 27, 2011 at 3:26 pm
SQLRNNR (7/27/2011)
ALZDBA (7/27/2011)
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
I just want you to know
I want...
July 27, 2011 at 11:22 am
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
I just want you to know
I want to hear...
July 27, 2011 at 11:16 am
Ninja's_RGR'us (7/26/2011)
On another note, the only safe backup I know is the one I've successfully restored and then ran an error-free checkdb() on it. ...
July 27, 2011 at 4:03 am
Are you refering the Oracle rollback segments ?
In sqlserver that information is stored in the database log file(s).
Pre-size it as much as you can, but if you chose to...
July 27, 2011 at 1:36 am
As stated, the restore puts the database back as it was at the time the backup has been created.
( files, file size )
However, you can move the files using the...
July 27, 2011 at 1:27 am
Viewing 15 posts - 1,801 through 1,815 (of 7,502 total)