That means that your original IF statement is the most performing if you rarely execute the SP using a value in your variable.

Which is one of the reasons the 'Switching'...

I think Jeff might have been talking about the SET...

GilaMonster (4/18/2008)In SQL 2008, you'll be able to use the query governer to limit resource usage by ad-hoc queries. In SQL 2005 that's not possible. The only way to prevent...

If possible I would go about adding a new column with EndDate which you would update every time there is a new record inserted (typical OLAP approach). It's better for...

Have you checked the duration of your kerberos tickets? Can they be expiring to quickly?

Or just write a small VB script...

Are you sure? Have you...

Thanks Philip,

Exactly what I was looking for!

Regards,

Hanslindgren

Yes, they are user databases.

I know about the attach/detach process but I wanted to know if anyone knows how to change the primary file. The DBs are all online 24/7...

Correct me if I'm wrong, but isn't this the current size?

Because of company policy we have to empty this drive and this includes removing (or moving away) any DB files on it. I have three primary files left on it...

Thanks, yes. BOL is usually a good source of wisdom!

But under Remarks:

Use DBCC SHRINKFILE to reduce the size of a file to smaller than its originally created size. The minimum...

Hi,

anyone heard any rumors about a release date yet?

Hanslindgren

Sounds only like you have a problem of parsing your query. Ensure that the syntax is correct (look especially at the comma characters).

I would start by indenting it 🙂 That...

Thanx! I will test it as soon as I encounter these packages again.

Hanslindgren