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...

sqldba_icon (6/24/2011)Eric not sure what do u mean by that question but that is not under my control. There could be a way to reduce the number of records but...

Back with SQL Server 2000, I would frequently leverage temporary tables and table variables for containing a small intermediate result which would then get joined with another query. However, since...

sqldba_icon (6/21/2011)

---

Can any one suggest based on there experience which one of these are preferred.

i) select * into #temp from tableA

ii) create table #temp (col 1)

insert into ...

Perhaps a user entered some trash for the email address in the web form. When I exec the following, I see several character values that are invisible in a grid...