Viewing 15 posts - 1,636 through 1,650 (of 7,498 total)
This may be a perfect occasion to get started with Powershell or SSIS to parse your documents.
SSC has some nice articles to get you started with both.
For powershell this one...
October 9, 2011 at 4:45 pm
The only thing you really need to take care of when using SSB is to build a good SSB monitoring system.
If SSB fails for some reason, it's better to get...
October 9, 2011 at 3:37 pm
No doubt SSB would be the better scenario for this request(because is can carry a payload so it would only query a single row at best (in stead of a...
October 9, 2011 at 1:17 pm
Is that db source for a snapshot db ?
DBCC LOGINFO may cause log file locking due to a bug in SQL2005.
I don't think it got fixed for 2005.
October 8, 2011 at 11:12 pm
check ISNULL or COALESCE in books online.
October 8, 2011 at 1:18 pm
For such restores ( everybody out I'll overwrite it all ) I always start the operation with
Alter database Yourdb set Read_only with rollback immediate ;
restore database ....
Notice there is...
October 8, 2011 at 1:16 pm
arjen.schrier (10/7/2011)
The datafile of the database has an initial size of 48GB while the data only occupies 29GB of the file.
DBCC SHRINKFILE only shrinks the MDF file...
October 8, 2011 at 1:14 pm
If I'm correct those are only for SSMS Express editions.
October 7, 2011 at 1:39 pm
Jeff Moden (10/5/2011)
ALZDBA (10/5/2011)
BTW you don't need million row objects to get into performance problems, so strive for most optimal setup as much as you can !
Heh... true enough. ...
October 5, 2011 at 5:44 am
CGSJohnson (10/4/2011)
Hi, Jeff. Sorry, but I cannot talk about it all. However, one use would be for the common goal of organizational structure.Thanks...Chris
Don't talk to Jeff about it,...
October 5, 2011 at 12:07 am
SQL Kiwi (10/4/2011)
GilaMonster (10/4/2011)
October 4, 2011 at 4:03 am
Stefan Krzywicki (10/3/2011)
SQL Kiwi (10/3/2011)
GilaMonster (10/3/2011)
The SA fans tend to paint faces green or green and gold for important rugby games. Dying hair green is also popular.
Yeah it's great fun...
October 3, 2011 at 10:26 pm
Roy Ernest (10/3/2011)
I do not have to worry about my stuff being stolen. No one in his right mind would want to do that... 😀
I have a second opinion about...
October 3, 2011 at 10:19 pm
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 1, 2011 at 12:17 pm
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Congratulations Jonathan and Ted
Added...
September 29, 2011 at 4:03 am
Viewing 15 posts - 1,636 through 1,650 (of 7,498 total)