Nope. Never heard of that one.

TheSQLGuru (4/7/2011)

---

sqldba_icon (4/6/2011)

---

Grant Fritchey (4/5/2011)

---

Yeah, local variables is a mechnism for defeating some forms of parameter sniffing. What it means is, instead of using a specific value to arrive at...

I agree with everyone, but just want to add an additional caution about GUIDs. They really can be problematic, so be sure, really sure, you need them before you implement...

You really need to take a transaction log backup. It sounds like NetApp isn't doing the job. I'd get on it immediately. The only proper way to resolve the full...

Even if you get a faster drive, you're going to realize the most improvement by moving stuff to separate drives. Even with SSD or something else, you will experience queuing...

There are a few situations where having your own mechanism for generating an identifier can make sense (distributed computing, stuff like that), but even then you'd probably b better off...

Yes, you can capture the plans for user defined functions. You have to use extended events and with them you can capture the plan that is used for the UDF....

sqldba_icon (4/6/2011)

---

Grant Fritchey (4/5/2011)

---

Yeah, local variables is a mechnism for defeating some forms of parameter sniffing. What it means is, instead of using a specific value to arrive at an...

mtassin (4/6/2011)

---

Grant Fritchey (4/6/2011)

---

My favorite software for doing this is Embarcadero ERStudio. It meets all your requirements and quite a few more. If you're going to work on your databases...

Lynn Pettis (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate...

Oh oh, Shongo!

I'm sorry, I don't understand what you're asking. Can you clarify further?

Each and every SQL Server installation is different. Different servers of different CPU speeds & numbers, with varying amounts of memory. Different databases with different applications and varying number of...

I wouldn't compare SSMS to your app. I presume they're doing different things. SSMS is loading all sorts of different bits of data as it opens and connects, stuff your...

My favorite software for doing this is Embarcadero ERStudio. It meets all your requirements and quite a few more. If you're going to work on your databases through a modeling...