Yeah, post the actual execution plans, I think that's where you'll see the problem displayed clearly.

Steve Jones - Editor (10/29/2008)

---

No guns at work. Chances are we're run out of developers and have to go code things ourselves. Now truncheons....

I thought this was a little silly...

That's an awful lot of work for something you can get for free if you do one of two things. You can save your delimited string to a file and...

You can set up the logins one of two ways. You can create a SQL login (not recommended) which has a name and a password. Better is to set up...

Something else is going on. All things being equal, a static set of data and a static set of code is going to return the same values. As others have...

Brackets are the way to go. If you used brackets within custom coding work in or around TSQL for anything other than naming database objects, you might be in trouble.

Does this mean I get to carry a gun at work now?

I promise, no more than one developer a week. 😀

Yeah, that's a pretty standard many-to-many relationship.

Take a look at sys.dm_db_index_physical_stats. That will give you quite a lot of information about the index, including the number of pages, density, space used, etc.

You can just look at...

ggraber (10/28/2008)

---

I spent most of the day researching TSQL Unit for the company I work for.

We are moving towards test-driven development and we are looking for a way to run...

SQL Compare has quite a bit more functionality than the Schema Compare tool in VSTSDBE. But, the new version coming...

What if you changed those to OUTER JOINS within the main part of the FROM clause and then had something in the WHERE clause to only limit the data when...

Unless you're using a third party tool like HyperBac, you'll need to restore the entire database to a different location, either a second database on the server or a seperate...

Best way to do that is to use the OUTPUT clause.

From BOL:

USE AdventureWorks;

GO

DECLARE @MyTableVar table( ScrapReasonID smallint,

...

Totally different toolsets to a large degree. Actually I use both together. I do use SQL Compare & SQL Data Compare a little less than I used to, but I...