Viewing 15 posts - 9,016 through 9,030 (of 19,562 total)
It won't work until 8/18, but here is a link for a post I wrote on the topic.
August 17, 2011 at 3:55 pm
Leo.Miller (8/17/2011)
SQLRNNR (8/17/2011)
You have 2 sockets and 8 processors.
Except if you licence Per Processor, you only pay for 2 licences, not 8.
This took me for ever to get my head...
August 17, 2011 at 2:08 pm
As Leo said, check the scripts and verify them. If you have tsql scripts in the commands with GO statements it could foul up the execution of your scripts.
August 17, 2011 at 2:02 pm
You have 2 sockets and 8 processors.
August 17, 2011 at 2:00 pm
Jim Murphy (8/16/2011)
Also, one of my larger DBA clients is doing a massive conversion from a dreaded SQL7 install (325GB DB) to a totally new vendor app, SQL2008, all...
August 17, 2011 at 1:48 pm
Evil Kraig F (8/17/2011)
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
August 17, 2011 at 1:31 pm
Grant Fritchey (8/17/2011)
Perry Whittle (8/17/2011)
Steve Jones - SSC Editor (8/16/2011)
Best advice, use backup compression first. If you have Enterprise Edition, you can use that
not available in SQL Server 2005, you...
August 17, 2011 at 1:30 pm
I would also verify that there is only one instance on that server.
It is a named instance, are you connecting to like the following:
Servername\InstanceName
or just
Servername
?
August 17, 2011 at 1:27 pm
bcsims 90437 (8/17/2011)
SQLRNNR (8/17/2011)
crookj (8/17/2011)
bopeavy (8/17/2011)
crookj (8/17/2011)
Daniel Bowlin (8/17/2011)
--------------------------------------------------------------------------------
Ray K (8/16/2011)
--------------------------------------------------------------------------------
busy
body
Bag
of Tricks
Bag of Doughnuts
Crave
Indulge
Indigent
August 17, 2011 at 11:03 am
crookj (8/17/2011)
bopeavy (8/17/2011)
crookj (8/17/2011)
Daniel Bowlin (8/17/2011)
--------------------------------------------------------------------------------
Ray K (8/16/2011)
--------------------------------------------------------------------------------
busy
body
Bag
of Tricks
Bag of Doughnuts
Crave
August 17, 2011 at 10:38 am
Is it a named instance? How are you trying to connect? Do you get an error message?
August 17, 2011 at 10:38 am
I'm in favor of adding disks. I am also in favor of implementing filegroup backups. The drawback to this is the time it will take you to figure...
August 17, 2011 at 10:37 am
jcrawf02 (8/17/2011)
SQLRNNR (8/17/2011)
August 17, 2011 at 10:32 am
I am not entirely a fan of getting a cell-phone from work. Too often the implication is that you must be ready to work 24x7x365 if they provide the...
August 17, 2011 at 10:05 am
Koen Verbeeck (8/17/2011)
Easy one today, although it seems the 'truncate is not logged'-myth stills seems pretty persistent.
Too persistent -it's like a nasty virus.
August 17, 2011 at 9:48 am
Viewing 15 posts - 9,016 through 9,030 (of 19,562 total)