Viewing 15 posts - 1,636 through 1,650 (of 7,502 total)
Well, for this being a new instance, you should apply SP4 !
No doubt about that, since you have to test it all.
Collation could indeed be an issue if you have...
October 10, 2011 at 8:46 pm
btw get used on using the statement terminator ';' because it will become mandatory in one of the next versions !
That will save you time fixing it later on 😉
October 10, 2011 at 1:46 pm
Jeff Moden (10/9/2011)
ALZDBA (10/9/2011)
SSC has some nice articles to get you started with both.
For...
October 9, 2011 at 6:48 pm
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
Viewing 15 posts - 1,636 through 1,650 (of 7,502 total)