i thought this was like which one will perform better 🙁

see of this can help you -

http://rajanjohn.blogspot.com/2008/04/dynamic-tsql-vs-case.html

do u mean this? update table_name set col1 = valu1, col2 = value2 where staffno = staff_value and period = period_value

I would appreciate any suggestions. Thanks!

GSquared (8/28/2008)

---

I don't know of a major standard. A few guidelines, like don't use reserved words in the table name, sure, but no real standards.

I use CamelCase for table...

I have attached the doc I use for myself.

Look whether your maintenance plans have shrinking included. Else, disconnect all the connections to the database and run a small shrink with a target size some 5-10 GB leseser than...

sp_spaceused

another confusing QOD

Once you have the alias, use the alias.column_name format. Also, avoid putting aliases that are reserved keywords, like status

Say, I had a wide Users table with 150+ columns. I split that to Users1 and Users2. If I have to update the name column in Users1 with a condition...

does your policies permit to login interactively to the server console with the service account? If so, do that and confirm the network drive permissions. Else set your login account...

5lakh = 500,000 🙂

Go to the color properties and create an expression for the color for alternate rows using IIF.

Here is one for SQL Server 2000.

http://www.sqldev.net/misc/waittypes.htm

I couldnt find one for 2005 though.