Viewing 15 posts - 37,021 through 37,035 (of 49,566 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic771726-338-1.aspx
August 17, 2009 at 8:03 am
Get out your database backup and restore it. You do have a backup, don't you?
If a database is detached while in the restoring state (not possible on SQL 2008), it...
August 17, 2009 at 8:03 am
Silverfox (8/17/2009)
I have no SQL Books and being freelance, I wouldnt last 5 minutes, If I turned up a a client site...
August 17, 2009 at 7:59 am
Paul White (8/16/2009)
The behaviour of the second statement rather depends on the setting of ANSI_NULLS.
Considering I never switch it off, anything I post about nulls can be assumed Ansi_nulls...
August 17, 2009 at 7:42 am
ta.bu.shi.da.yu (8/16/2009)
You can't do an outer join from the where clause...
You can't in a DB with compatibility set 90 or higher (ie SQL 2005 or 2008). It was possible on...
August 17, 2009 at 7:40 am
The series kinda got split in 2008. Haven't seen an equivalent to the 4th book, but if you want internals, you want this one.
August 16, 2009 at 2:25 pm
I need to correct myself here. Surprised no one picked up on this....
GilaMonster (8/10/2009)
Also, try to avoid IN. While checking the existence of some values, then use EXISTS instead of...
August 16, 2009 at 12:32 pm
Sarab (8/16/2009)
August 16, 2009 at 10:56 am
Steve Jones - Editor (8/16/2009)
they don't stay up to date. They are a point in time. To update it, you need to either drop...
August 16, 2009 at 9:48 am
Congratulations. 😉
This is either a wonderful opportunity or pending disaster, which it will be is up to you.
Here are a few resources to start with.
http://www.sqlskills.com/BLOGS/PAUL/post/Becoming-an-involuntary-DBA-youre-not-alone.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/RunAs-Radio-interview-on-being-an-involuntary-DBA.aspx
Some things that you need to...
August 16, 2009 at 8:48 am
ps (8/16/2009)
In mirroring, you cannot access the mirror database at all unless failover happens.
You can, providing it's Enterprise edition. Create a database snapshot on the mirror (has to be synchronised)....
August 16, 2009 at 8:42 am
There's no default duration or setting that affects a checkpoint's duration. You can change the recovery interval, which affects how often the checkpoint runs, nothing else.
How long a checkpoint takes...
August 16, 2009 at 8:39 am
Look up SUM and GROUP BY in the SQL Books Online (SQL Help file, press F1 in management studio to open)
If you can't get it right, post what you have...
August 15, 2009 at 2:56 pm
Viewing 15 posts - 37,021 through 37,035 (of 49,566 total)