If you are on a domain the most secure method is to use Windows Authentication only when you install SQL Server. If you have to have mixed authentication, you...

I'd suggest changing the query to get the trace file name from:

select convert(varchar(1000),path) as path from sys.traces where id = 1

To

select convert(varchar(1000),path) as path from sys.traces where is_default =...

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix...

Jeff Moden (5/4/2015)

---

There's also no excuse for people breaking out their "I've got 20 years of experience" rings. which looks like might have been the start of it all. ...

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly performing query, but without...

FYI, Erland Sommarskog has a new set of articles on Error Handling in T-SQL that y'all might be interested in. It starts here, http://www.sommarskog.se/error_handling/Part1.html.

There really isn't a way to fix this problem without a code change. The issue is that ALL the data is being brought across the pipe to filter down...

I'd put together a trace to verify that this is the issue. I don't see any way that can be the ONLY statement in the batch because it can't...

According to this BOL article, you need ALTER TABLE on the table the trigger, and according to this BOL article, db_ddladmin does not have ALTER TABLE.

I tend to create specific...

What is the security context the linked server is using? Unless that user has pretty elevated permissions it can't access the statistics in order to find the best execution...

I'm not sure how this query can be a blocker with the NOLOCK hint. When I run a query using the NOLOCK hint the only lock taken is a...

Wow Lynn that's one of the best one I've seen in a long time. Give me the code so I can pass my final. You never know, the...

And here I am thinking this was a MASH reference, http://mash.wikia.com/wiki/Walter_%22Radar%22_O%E2%80%99Reilly😀

I'm don't know why it is doing what it is doing, but I can say that if you look at the execution plans for the simple select vs. the cursor...

An index with only 3 pages likely won't be able to be defragmented because it is on a mixed extent and there isn't a way to move the rows onto...