GilaMonster (10/4/2007)

He could connect to SQL normally (not DAC), but queries, even against the system views, just ran and never finished. Hence he was killing spids blind (without even knowing...

I've used the conditional syntax in WHERE clauses, but a conditional ORDER BY? That essentially guarantees not using indexes, and ORDER BY without being able to use indexes tends...

As the typical answer on here goes...."it depends". On lots of things.

You can run just about anything you wish from BCP. A stored procedure that returns result is perfectly appropriate, or a view, or a function.

By the way - BOL...

You can install the client tools for SQL on any machine, free. That gives you access to any of the tools you wish to use (query analyzer, DTSrun, osql,...

You could also just try to see if the shortcut went bye bye. Just double-check to see if you HAVE a ssms.exe file on the system or not. ...

What I'm saying is that each time you're adding a new column, you're adding a new join to the mix, which adds a lot of effort for not a lot...

If you're looking at this on a Win2k3 server runnin gIIS in work-isolation mode - then you want to look within the Application pool definition to find the service account....

Log on to the server using the credentials of the IIS service account and try that again. That's one of the big differences here between you running it, and...

You want to take a look at the fancy new PIVOT feature that "flattens and turns" your data. All in one shot. There are several options as to...

There are definitely different dynamics to take into account when you're dealing with systems that have heavy updates/continuous vs reporting only or analytical only type server. One area in...

I tend to try to avoid updating system tables directly unless I have to. It tend to leave me with a steaming pile of melted components or corrupted system databases....

John's solution should run faster since it's using a derived table concept instead of a correlated sub-query.

CSQ's (meaning - the sub query uses elements from the outer query...

We tried leaving a tray of donuts near the door - but they never survived more than a few minutes....We just don't have that kind of willpower:)

That being said -...

Just curious - why are the two phone numbers different data lengths (varchar(13) vs varchar(10))? Is there "garbage" you get in you need to clean out? Also - why...