permono.sam (5/26/2012)

---

What other factors for example? I do not mention because maybe I do not know that some things will be those :-D. Looks like the plan in...

Sure. 😎

Link to INSERT documentation: http://msdn.microsoft.com/en-us/library/ms174335(v=sql.105).aspx

Example code:

DECLARE @temp1 AS TABLE

(

account_id char(5) NOT NULL

...

Msg 207, Level 16, State 1, Line 2

Invalid column name 'account's value'.

Msg 102, Level 15, State 1,...

Why do you have comma separated values in your...

Jeff Moden (5/25/2012)

---

An example of what I mean, though... We're still "stuck" on SQL Server 2005 at work. If I wanted to take a break at lunch and answer...

It was not available in SQL Server 2000, so if your database is set to 2000 compatibility mode (80), you...

Please bear in mind that...

Your 2000 instance probably had the CURSOR_DEFAULT database option set to LOCAL (the default is GLOBAL).

See http://msdn.microsoft.com/en-us/library/ms190249(v=sql.105).aspx

Example change script:

ALTER DATABASE <database_name>

SET CURSOR_DEFAULT LOCAL;

permono.sam (5/26/2012)

---

From what I have read, when optimizer running a query, it searches best plan for using index, join mechanism, etc. So how do I force the SQL Server...

Gullimeel (5/26/2012)

---

If i were in such a position I would do following:

Perform a small test for alternate methods using the most common load Iincluding dmls/maintenance) and see which one is...

GilaMonster (5/22/2012)

---

andersg98 (5/22/2012)

---

Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan the...

Gullimeel (5/26/2012)

---

I do not want to go that path anymore. I was not testing the performance of max/min or top 1.I used wrong operator to show what i wanted to...

Gullimeel (5/26/2012)

---

Next time I wont save the typing efforts because it has caused much more typing then i thought it would save me(not a nice optimization decision:-)) so that discussion...

You're missing the point. I'm not talking...