IMHO Mr. Moden is absolutly correct.

Shortly after starting my new job, I was thrown some SQL that no-one had been able to tune. I discovered that they basically used...

Pet Peeve on...

Would it be difficult for MS to give the option whether or not to allow other windows to grab context from the current one?

Back in the day on...

ditto Gsquared.

If you must use a cursor, use the SQL Server one, do NOT write your own in TSQL. I've never see a "hand written" cursor come anywhere close...

If you've proven yourself on just about any db architecure you should be fine. IMHO, this job is the ability to find answers (on the internet and in books),...

The reason I used reverse is if you have more subdomains...I believe PARSENAME is limited to 4 parts, because that is the maximum you ever need for object names.

select PARSENAME('abc.def.ghi.jkl.mno',...

I believe this might work - not sure how effecient tho...I would recommend using the front end to do this rather than the database. But it was fun trying...

You can wrap the following around the SQL, and it will show you the parse & compile time for each execution. It will also show you the IO -...

We had to add that type of column to all existing tables on an existing db, and similar to you, every query was modified to refer to that column. ...

A Checkpoint will only truncate the inactive part of the log when in Simple Recovery mode. In the other 2 modes you have to backup the transaction log in...

Try the system view sys.sql_logins.

http://msdn2.microsoft.com/en-us/library/ms174355.aspx

jg

A simple, but I think "clear" way to look at it:

A unique index is the physical implementation that SQL Server uses to enforce a logical PK.

(SQL Server defaults to a...

I tried this and found the same behavior - searching for a string - where col5 like '[[]asdf%' . If I search on a indexed varchar column, it does...

This might be helpful?:

SELECT o.name as table_name,coalesce(i.name,'HEAP')

,s.user_seeks, s.user_scans, s.user_lookups, s.user_updates

,s.user_seeks+s.user_scans+s.user_lookups+s.user_updates as user_tot

,s.last_user_seek, s.last_user_scan, s.last_user_lookup, s.last_user_update

from sys.indexes i

LEFT OUTER JOIN sys.dm_db_index_usage_stats s

ON i.object_id=s.object_id and s.database_id=db_id()

AND i.index_id=s.index_id

LEFT OUTER JOIN sys.objects...

Create a database role, set up the permissions at the role level, and assign the group to the database role. I believe that will accomplish what you are trying...

I notice that the INDI_ID and PROD_ID are NULL on the first table and NOT NULL on the second table. I have seen that be a problem for using...