Viewing 15 posts - 7,606 through 7,620 (of 19,564 total)
restoring 2.5TB database for logshipping secondary. Paint is drying very fast!!
December 7, 2011 at 8:38 pm
December 7, 2011 at 8:36 pm
That's kind of a big topic for a forum question.
Have a look through these tutorials and see if they help.
http://msdn.microsoft.com/en-us/library/ms170246(v=sql.90).aspx
December 7, 2011 at 8:21 pm
Evil Kraig F (12/7/2011)
SQLRNNR (12/7/2011)
try using a cte and a row_number() ranking function.Put your query in the cte with that ranking function, then select from the cte where rownum=1
I would...
December 7, 2011 at 8:20 pm
Do a left join to each of those tables with the appropriate fields specified in the on clause. IN addition add 'and suchandsuchfield = 1'
e.g.
Left Outer Join BoatingWarningQaulityCodes
On...
December 7, 2011 at 5:42 pm
There is not a DMV that replaces sp_who or sp_who2 in its entirety.
If you are looking for a query that is useful you could try whoisactive by Adam Machanic, or...
December 7, 2011 at 5:24 pm
Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.
The spindles seems off.
The local drive is far...
December 7, 2011 at 4:33 pm
1. Yes, integrated is better. Many leave SQL Login enabled as a backup as well.
2. You could try creating a database user for your application without login
December 7, 2011 at 11:47 am
try using a cte and a row_number() ranking function.
Put your query in the cte with that ranking function, then select from the cte where rownum=1
December 7, 2011 at 11:40 am
Have a look at this connect item
It lists some patches and SPs that should fix the issue.
December 7, 2011 at 11:38 am
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
bcsims 90437 (12/7/2011)
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
mutinyHow can you do that when you're the boss???
Multiple personalities?
understatement
says who?
Legion
December 7, 2011 at 11:17 am
bcsims 90437 (12/7/2011)
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
mutinyHow can you do that when you're the boss???
Multiple personalities?
understatement
December 7, 2011 at 11:04 am
Where possible and feasible I like to try and consolidate - even if that means using Enterprise edition. Of course, homework has to be done before doing such a...
December 7, 2011 at 9:05 am
L' Eomot Inversé (12/7/2011)
Steve Jones - SSC Editor (12/7/2011)
Jeff Moden (12/7/2011)
Revenant (12/6/2011)
Jeff Moden (12/6/2011)
December 7, 2011 at 8:51 am
Viewing 15 posts - 7,606 through 7,620 (of 19,564 total)