GilaMonster (9/21/2010)

---

If you're interested, the snapshot is created using the NTFS alternate stream feature, and is created as an alternate stream of the data files, hence same drive and same...

I'm gonna bet on the field. 😉

Because there's no way I'm gonna disagree with you until...

GilaMonster (9/21/2010)

---

Craig Farrell (9/20/2010)

---

Edit: Alternate option if you can't run this in a new db... use the (NOLOCK) hint on the sql call for both tables, at the very least...

You're looking for the HAVING clause

SELECT name,Age,empcode FROM tbl GROUP BY name, age, empcode HAVING count(*) > 1

Hm, Coffee, you have a valid point. ...

chrisjkelly (9/21/2010)

---

Chaps - I thoroughly appreciate your help. I've restarted the service (not the agent this time (Doh!) and its cleared the space issues. I cant beleive how...

One item of note: If you manually set the tempdb size via properties, it rebuilds to that size even though it resets the database. You may still need...

chrisjkelly (9/21/2010)

---

Craig,

Thanks for the advice and for keeping it simple.

Is it safe to carry out a shrink on the tempdb? and would simply stopping our application service on the...

I'd personally use a proc with a bunch of IF/ELSE IF, if I had to do this. Pretty? No. Easy to maintain? No. Best way I've...

Well, once the db grows to a size it doesn't autoshrink, usually. If you're running DBCC regularly you'll want to leave the space there so it doesn't have to...

Since you admit you're not a DBA I'll do my best to keep this easy. 🙂

You can shrink the tempdb via the interface. Open the server up, open databases...

Well, if I'd ever seen a request for a tally table solution, this would be it. 🙂 Much easier to build out the necessary pre-array this way.

Check out this...

Here's a link to an article that describes what you're looking for:

http://weblogs.asp.net/steveschofield/archive/2005/12/31/change-schema-name-on-tables-and-stored-procedures-in-sql-server-2005.aspx

It was the second link when I typed in at google: ms sql change object schema.

😀

The command you're looking...

Okay, what the check is trying to do is be able to scan the table, end to end, and make sure it's correct, allocated, etc etc.

To do this, without screwing...