OCTom (6/30/2011)

---

Teamwork is overrated. I think the skillset and the willingness to learn new skills is more important. I have yet to see an employer value teamwork highly. They speak...

Revenant (6/29/2011)

---

Eric M Russell (6/29/2011)

---

. . . Even a RDBMS like SQL Server which is built exclusively on Win32/64 executables should be able to retain that functionality regardless of wether...

TravisDBA (6/29/2011)

---

opc.three (6/28/2011)

---

I am curious...I am not sure what you mean. Maybe it would help if I knew your standard...

PaulB-TheOneAndOnly (6/29/2011)

---

Eric M Russell (6/27/2011)

---

Actually, I think it may be possible for multiple SQL Server instances to share the same database files, but one requirement is that the database must...

Decades ago, mainframe computers were very mechanical and actually did use oil and hydraulic cooling systems for the disk storage systems. They even experimented with steering wheel input devices.

http://www.flickr.com/photos/maisonbisson/1634408/

opc.three (6/28/2011)

---

I am curious...I am not sure what you mean. Maybe it would help if I knew your standard for...

"Changing the oil" is a good analogy for rebuilding the indexes, because indexes are something...

Craig Farrell (6/27/2011)

...

I agree, and it sounds like someone used a temp table for logical ease then for optimization concerns. Moving to temp tables of any form (not CTEs)...

Actually, I think it may be possible for multiple SQL Server instances to share the same database files, but one requirement is that the database must be on a read-only...

Craig Farrell (6/25/2011)

---

Eric M Russell (6/25/2011)

---

Craig Farrell (6/24/2011)

---

...

Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? ...

Craig Farrell (6/24/2011)

---

...

Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? It's merely there to allow...

The decision of temp table vs table variable vs CTE or etc. depends on how this intermediate resultset will be leveraged within the stored procedure.

Where I've mostly used table variables...

GilaMonster (6/23/2011)

---

ankit.shukla1105 (6/23/2011)

---

The question was to practically demo how char uses up more space than varchar, so here's the demo.

I created two tables, VarChar_Table and Char_Table as below:

create table Char_Table...

Some types of events warrant not just logging or auditing, but sending an immediate notification to the DBA's attention. For example there is no good reason for the following errors...

Jeff Moden (6/24/2011)

---

I wasn't going to post until I got home from work to give some demo's (I don't have time while at work) but one of the things to...