jcrawf02 (11/6/2009)

---

Geek of the Week is too...

Actually, that might happen. It...

Great time so far. This is an excellent community of individuals.

Sitting in the hotel in Seattle. Actually I'm leaving now to go downstairs and start meeting the denizens of the PASS Summit.

Tried the search "execution plans" and received a VERY high number of hits. Only problem was the results show very little. First one said, Execution Plan and underneath it said...

You can connect directly to TFS from SQL Server Management Studio. It will allow you to create a solution and add scripts to it, check them in & out, etc....

I hate to say it, but I think it's you. I very seldom have two instances of SSMS open and then it's usually one logged into the production servers and...

Small scripts that I use all the time go into Red Gate SQL Prompt. Bigger scripts go out to a sharepoint site. All our projects are built from source control,...

GilaMonster (10/29/2009)

---

School?

It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your...

Magy (10/29/2009)

---

Thanks everyone!

I don't think I would be able to use a .NET session or state table, because I need it to be in SQL Server.

Reason being,...

meichner (10/29/2009)

---

Grant Fritchey (10/29/2009)

---

The Red Gate database documentation tool, SQL Doc, will do it I think.

The problem is, it's really easy to get a circular reference. All you need is...

I'm pretty sure that one can be done on the fly and doesn't require a restart (but I could be wrong). I'd have to look it up to be 100%.

ERStudio is probably one of the highest quality modeling tools you're going to run into. Almost anything else is a step down. It might not function like Word or Excel,...

I agree. Temporary tables are meant for temporary storage within a single connection's life on the server, not for the entire time an application is being used. You need a...

Hey Flo,

I think you might want to try Wesley's idea. Think about it like tempdb, if it's shrinking and growing depending on load within the range you specified, it might...