Viewing 15 posts - 316 through 330 (of 459 total)
While all these accounts are good for user passwords, you may want to consider a truly random and long password for service accounts and 'sa'. Anytime we install a...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 20, 2009 at 7:43 am
Krishna Potlakayala (5/19/2009)
Gaby Abed (5/19/2009)
RPSql (5/16/2009)
-if percent fragmentation value is between 5% to...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 20, 2009 at 7:22 am
Here's a great link on what not to do with trans log backups.
To summarize it:
1. Don't break the backup chain with NO_LOG/TRUNCATE_ONLY.
2. If you really must, immediately do a full...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 19, 2009 at 10:00 am
RPSql (5/16/2009)
-if percent fragmentation value is between 5% to 30% then we will...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 19, 2009 at 9:39 am
GilaMonster (5/15/2009)
GSquared (5/15/2009)
Gail: Check out the second story on this page[/url]. You'll get a chuckle out of it.
Hehe. That's not an uncommon comment. I showed someone a photo...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 15, 2009 at 9:58 am
Gaby Abed (5/14/2009)
Wow! At ten posts per page, mine would be Four Thousand, Four Hundred, and Forty-Two! Woohoo!
Make it: Four Thousand, Four Hundred, and Forty-Four!...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 2:14 pm
Wow! At ten posts per page, mine would be Four Thousand, Four Hundred, and Forty-Two! Woohoo!
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 2:10 pm
Sam Shiell (5/11/2009)
Yes, a questionable Management decision has left us at short notice without a DBA. As the...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 1:34 pm
Meredith Ryan (1/21/2009)
In...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 1:17 pm
Sam Shiell (5/8/2009)
Interesting point. However if I don't do the dba stuff it doesn't get done, and if anything goes "bang" then we're dead.
My company is the registering authority...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 1:10 pm
Samuel Vella (5/14/2009)
Nothing wrong with your querythe problem is with
sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, NULL)
Which is always going to take a long time to run
I guess that's the nature of...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 14, 2009 at 8:31 am
Jeff Moden (5/13/2009)
All good stuff about the laptops folks. Thanks. I'll let you know what I end up with.
Jeff, one more thing about laptops with regards to 32...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 13, 2009 at 2:11 pm
Ken_R_Vickers (5/12/2009)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 13, 2009 at 7:50 am
Jack Corbett (5/13/2009)
Luke L (5/13/2009)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 13, 2009 at 7:43 am
Bob Hovious (5/12/2009)
Ohhhhhhhhhhhh
I call up Engineering... holler "Gimme warp three"
I got a half a billion Klingons all as pissed as they can be
And the...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 12, 2009 at 10:45 am
Viewing 15 posts - 316 through 330 (of 459 total)