Viewing 15 posts - 76 through 90 (of 279 total)
Hi DHeath
If you manage 20+ servers, you might want to look into Powershell. I manage 100 of the blighters, and powershell has made my life a lot easier!
Check out this...
February 10, 2011 at 9:52 am
Hi
This should get you started:
http://msdn.microsoft.com/en-us/library/aa337562%28v=SQL.90%29.aspx
(Edited link to point to SQL2005 specific page)
February 4, 2011 at 7:40 am
No, it's not a good idea at all - and also rather pointless in this case, as all it will do is grow again
See here for a detailed explanation as...
February 4, 2011 at 7:28 am
EdA
You could either use T-SQL or SSIS for this (ie, a T-SQL type jobstep, or an Integration Services type job step.)
T-SQL would be something like:
insert into ERPPLUSDB.dbo.NCMROrders
select col1, col2, ...,...
February 3, 2011 at 8:04 am
s/he's dissed another poster's spelling now. In the words of the people from Teh Interwebz: "wat?"
February 3, 2011 at 5:16 am
I highly recommend looking through some of the videos on the SQLBits website http://www.sqlbits.com
SQLBits is probably the largest SQL Server conference in Europe. After the conference, videos of the presentations...
February 3, 2011 at 3:09 am
That's what we do when patching our production cluster
January 14, 2011 at 8:02 am
I used the method described in this blog post to identify what was causing my tempdb to grow:
http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html
Basically you query a couple of the DMVs every 2-3 minutes and then...
January 14, 2011 at 7:00 am
I recommend you have a good read of this article by Paul Randal, to get a better idea of what happens under the hood during restores
January 14, 2011 at 6:50 am
Ray K (1/12/2011)
Oh, now you've done it! 🙂"Oh the weather outside is frightful, but inside, it's so delightful . . . "
Now you've done it, I now have a craving...
January 12, 2011 at 8:05 am
The Saddest Sound, by The Devastations
I wish it would go away - lovely song but very depressing!
January 11, 2011 at 10:18 am
Jeff Moden (1/10/2011)
mazzz (1/10/2011)
Frances L (1/10/2011)
well , I think if there 100%. then it will different. Thx.True. Trust me to worry about decimals and miss the obvious 🙂
Did you also...
January 11, 2011 at 4:58 am
Frances L (1/10/2011)
well , I think if there 100%. then it will different. Thx.
True. Trust me to worry about decimals and miss the obvious 🙂
January 10, 2011 at 8:10 am
Viewing 15 posts - 76 through 90 (of 279 total)