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

seth 98372 (6/23/2011)

---

Eric,

Thank you for your thoughtful response here. OPC.Three is right, though, we're doing the initial SQL Query in java, then processing the results (in java), and per each...

Har-Har! I wish this were a homework assignment... This is me at my job trying to improve our app's performance. My boss prides himself as an SQL expert, and he's...

The worst type of errors are the are not really errors at all, but rather user misunderstandings about SQL functionality (or just typos made in haste) that compile, run with...