You should be aware that someone in the securityadmin role can easily give themselves sysadmin access.

You can see a discussion of that on this thread:

http://www.sqlservercentral.com/Forums/Topic1009352-1550-1.aspx

I think a better solution is...

Run a query against the information_schema.tables view in each database on the server to find out the one(s) it is in.

I prefer not to have music playing when I work, because it tends to get me working at the pace of the music, and not the pace I should be...

TheSQLGuru (11/30/2010)

---

The only thing that matters here is the OP's request: "please help me to decide on using UDF?"

I will help you with that: NEVER, EVER, EVER USE...

Fixed, I hope.

You can use the script on the link below to calculate the break even point for Processor vs. Server/CAL licensing.

Calculate SQL CAL Break Even Point

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153583

That is all determined internally by the database engine, not by the order of the joins.

You may also see a message in the SQL Server Error log like the following that has the name of the host it is running on. This message should...

Grant Fritchey (11/29/2010)

---

Not only is it running on SQL Server, but you can watch the monitoring on the system, live, from here[/url]. Check out how well it operates and see...

select

case

when col1 = 1 then 'col1'

when col2 = 1 then 'col2'

when col3 = 1 then 'col3'

... and so on ...

else '' end

from

MyTable

99.99999% of the time, that is going to be a very bad idea.

Just store the data is a datatype that most closely fits the real type of the data.

Is the fill factor on the indexes very low?

Do you have any columns of datatype TEXT, NTEXT, IMAGE, NVARCHAR(MAX), VARCHAR(MAX), or VARBINARY(MAX)?

"GO" is not a SQL Statement, so you should just remove it.

GO is a batch separator for some clients.

You should post questions on the...

Geoffrey Wrigg (11/19/2010)

---

This talk about code efficiency reminds me of a "war story" from college (in the mid-1980s).

The college had a couple of mainframe VAX/VMS computers, with terminals in several...