Viewing 15 posts - 421 through 435 (of 631 total)
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
Thanks in advance.
P.S. Please don't ask for DDL and sample data as...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
March 13, 2014 at 7:03 am
Dird (3/11/2014)
OK thanks for the clarity. I guess I'll just add an extra step to fullscan on that particular table after doing an all-round sp_updatestats.
Are you getting bad query plans...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
March 11, 2014 at 4:59 am
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
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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....
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 27, 2014 at 3:36 am
New Born DBA (2/26/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 25, 2014 at 8:11 am
Fictional (probably) but on topic http://dilbert.com/strips/comic/2004-06-23/
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 25, 2014 at 5:17 am
Gazareth (2/19/2014)
Grant Fritchey (2/18/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 13, 2014 at 4:17 pm
venoym (2/13/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
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...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 13, 2014 at 4:34 am
Viewing 15 posts - 421 through 435 (of 631 total)