in action figure

The other issue could be running over 8060 bytes for a row. its possible since a varchar(100) can take up as much as 102 bytes. SQL Server...

rmudway (11/5/2012)

---

Hi sanket!!

Thanks for your response, that was a nice little piece of info. I found that my test machine had the whole DB in RAM, but the Main SQL...

over flow

Since you are asking about the output the best thing to do is post some input and the complete query and expected results for the given input. what i...

Sean Lange (11/2/2012)

---

Was thinking about this during a meeting and one challenge with capnhectors code is that it could get unwieldy pretty quickly.

If the list contained more values for manufacturer...

Another method is with an OR in the where clause and use parenthesis to group your and conditions.

;with cte as

(

select 'Volvo' as CARS, 2001 as Year union all

select 'Volvo',...

menon.satyen (11/2/2012)

---

Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/%5B/quote%5D

Careful with the missing index DMV's. it may suggest 2 indexes with slight differences that could be accomplished with one index....

One thing to note is that sql server defaults to a clustered primary key. If the tables have a Primary key they most likely (Note: not always and certainly...

With...

David92595 (11/1/2012)

---

okay, so for starters I'm not brand brand new to SQL. Maybe I should have been a bit more clear about that. I've got about a year...

you could also go with an evaluation copy. that would give you 180 days to license the server. however if you go that route i would not go...

George M Parker (11/1/2012)

---

capnhector (11/1/2012)

---

if designed properly and tested...

pveilleux (11/1/2012)

---

Hello, everyone....

I am about ready to install a new SQL Server to support a SharePoint installation, and need to acquire a SQL 2008 R2 license. We're just about...

i would tend to disagree. you need to...