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...

The costs are just estimates. Proof in the differences between the two plans will be in the compile and execution times, and the amount of I/O.

Several things about the queries...

You basically have it. TSQL isn't the best place to worry about formatting data. Convert is a pretty good method. But if you really need to break it down, take...

george sibbald (10/27/2008)

---

no,no,no, no fees to join sqlservercentral, ever, it would ruin it.

People have a problem, they do a search, a post from this site pops up, and voila there...

Are you sure that it's not a view or a table valued function?

Is there an INSTEAD OF trigger on the table (if it is a table)?

If you are posting answers to questions out on the forums (or, in my case, trying to), you have to be approaching it from a place of enlightened self-interest. Yes,...

Sure sounds like parameter sniffing. Since it's 2005, you might try using the OPTIMIZE FOR method to get good execution plans.

You might try setting these values into two other...