Viewing 15 posts - 421 through 435 (of 629 total)
This should help.
http://technet.microsoft.com/en-us/library/cc280359(v=sql.105).aspx
If you're new to SQL Server, http://www.SQLSklls.com accidental DBA series of posts, and also their Misconceptions series are something I'd highly recommend.
Also http://sqlinthewild.co.za/index.php/category/sql-server/admin/ isn't bad
March 11, 2014 at 4:48 am
Exactly as Gail says, nothing.
Briefly, when you start up SQL Server, as you run queries it takes the data from the discs to fulfil those queries. This is slow....
March 11, 2014 at 3:58 am
dwain.c (2/26/2014)
andrew gothard (2/26/2014)
dwain.c (2/26/2014)
kenneth.mofokeng (2/26/2014)
I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is several month ago
Since you don't have...
February 27, 2014 at 3:36 am
New Born DBA (2/26/2014)
February 26, 2014 at 2:53 pm
dwain.c (2/26/2014)
kenneth.mofokeng (2/26/2014)
I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is several month ago
Since you don't have backup , try...
February 26, 2014 at 7:36 am
New Born DBA (2/25/2014)
I just received an email saying that "The backup was running at that time, which could have froze things up for a moment".
If they're talking about the...
February 26, 2014 at 4:51 am
JoshDBGuy (2/25/2014)
Doesn't the execution of thousands of ad-hoc queries bloat the procedure cache? I though that would cause some performance degradation.
Absolutely.
Even (IIRC) with the optimize for Ad-Hoc queries sticking plaster...
February 25, 2014 at 8:11 am
Fictional (probably) but on topic http://dilbert.com/strips/comic/2004-06-23/
February 25, 2014 at 5:17 am
Gazareth (2/19/2014)
Grant Fritchey (2/18/2014)
February 19, 2014 at 2:50 am
jasona.work (2/13/2014)
Man, it got quiet in here...Is the watercooler empty or something?
It's quiescent?
February 14, 2014 at 5:13 am
Evil Kraig F (2/13/2014)
I'm going to fire a bombshell that will probably get me shot, but here it is:I rarely use FKs.
.
So you don't want free data integrity, and you...
February 13, 2014 at 4:17 pm
venoym (2/13/2014)
February 13, 2014 at 2:41 pm
GilaMonster (2/12/2014)
I can't understand why he claims implementing relationships manually in the application (hence writing code to do so) could possibly be easier or less time consuming than...
February 13, 2014 at 4:34 am
If the only difference is that some rows may have certain data elements updated and others can't, I'd say they belong in the same table (there are bound to be...
February 12, 2014 at 9:15 am
peter.cox (2/12/2014)
February 12, 2014 at 7:11 am
Viewing 15 posts - 421 through 435 (of 629 total)