Viewing 15 posts - 14,761 through 14,775 (of 19,564 total)
bitbucket-25253 (4/16/2010)
CREATE PROCEDURE sp_who2 --- 1995/11/03 10:16
@loginame sysname = NULL
as
set nocount on
declare
@retcode ...
April 16, 2010 at 4:07 pm
Lynn Pettis (4/16/2010)
CirquedeSQLeil (4/16/2010)
If so, can you verify for me if ANSI_NULLS is off in sp_who2 on your server?
I believe it would be since...
April 16, 2010 at 3:31 pm
Lynn Pettis (4/16/2010)
Jeff Moden (4/16/2010)
dma-669038 (4/16/2010)
April 16, 2010 at 3:22 pm
Jeff Moden (4/16/2010)
April 16, 2010 at 3:20 pm
Lynn Pettis (4/16/2010)
Test, test, and test again!
Absolutely. Do it on a non-prod system first if possible. Document the changes made and then check for improvement or degradation of...
April 16, 2010 at 3:17 pm
Roy Ernest (4/16/2010)
nah...Its pretty short. Just 4 to 5 pages in word doc..... 🙂
Posting it for SSC or somewhere else?
April 16, 2010 at 3:16 pm
Anybody out there have SQL 2000 installed?
If so, can you verify for me if ANSI_NULLS is off in sp_who2 on your server?
I believe it would be since that is the...
April 16, 2010 at 3:15 pm
Roy Ernest (4/16/2010)
Yep...I was able to do another 25% of the article... Maybe by the end of the week, I will have it ready for review..🙂
Long article or what?
April 16, 2010 at 2:58 pm
DTA will recommend bogus indexes. It also recommends good indexes from time to time. Depending on your queries, performance and execution plans - you may actually need to...
April 16, 2010 at 2:51 pm
Database backups are separate from filesystem backups.
If you want the database to be backed up you need to use a backup designed for use in SQL server, which requires SQL...
April 16, 2010 at 2:25 pm
Jack Corbett (4/16/2010)
CirquedeSQLeil (4/16/2010)
I agree that the technical posts do tend to take a longer time to write. I wonder how many of my posts I could turn into...
April 16, 2010 at 1:23 pm
I enjoyed revisiting this article. This is a job well done.
April 16, 2010 at 1:20 pm
I appreciate the thank yous and recognition. I also appreciate when that recognition is in the form of gifts, cards, money, incentives. It is good to know that...
April 16, 2010 at 1:18 pm
Kit G (4/16/2010)
Tom.Thomson (4/16/2010)
Hypopotamus 😀 (would that be: under water; or small water ; or by means of water ???)
What about the Hyperpotamus? A hippo after drinking...
April 16, 2010 at 1:11 pm
Gianluca Sartori (4/16/2010)
jcrawf02 (4/16/2010)
Can you imagine how tough your life would be if you didn't know Jack?I'll bet he's sick of that joke, but I thought it was funny :hehe:
I'm...
April 16, 2010 at 10:20 am
Viewing 15 posts - 14,761 through 14,775 (of 19,564 total)