LightVader (5/17/2012)

---

That's how I was hired most recently, only they called me a temp...

Great article Steve - as usual - and good timing too, as there is a fair amount of discussion taking place on different approaches currently, including a mixture of the...

Hugh Scott (12/14/2010)

---

amenjonathan (12/14/2010)

---

Thanks merlin for your reply and Hugh for this article. Looking forward to the next two installments.

Anybody have any idea what happens when you do not add...

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[truncate_partition]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[truncate_partition]

GO

/*

- Procedure Name: dbo.TRUNCATE_PARTITION

- Date of creation: 06-Jan-2010

- Author- Mr. Vidhaydhar Vijay Pandekar

-...

Great script Vidya!! Thanks for posting this!

I found the earlier comments from Maurice and JFoster quite helpful as I encountered the same issues.

I also found that if the exisitng partition...

Thanks Tim, it's good to see this important list is being updated

Cheers mate

Chris

Brillient!!!

Have been looking for a Central trace flag list for ages - and now it exists on SSC - nice one!

😀

Hi Steve

Not sure this line in the article was intended?

"SQL Server 2008 RTM just ended its support lifetime"

Christian Buettner-167247 (1/8/2010)

---

Well you posted a question and...

brdudley (1/7/2010)

---

This help page lists the logical operators (http://msdn.microsoft.com/en-us/library/ms189773(SQL.90).aspx) including IN.

I don't doubt that an entire clause containing IN is a predicate, but perhaps IN is the operator...

Nice article Sadequl - love your work!

🙂

I agree.

The policy of not supporting older software versions may work for other platforms, such as office applications to entice "latest & greatest" upgrades, but this approach does not work...

Great advice Steve - I have just arrived home after a 1.5 hour Tae Kwon Do training session tonight after work.

We have a tournament Saturday week, just within our club,...

I agree and also use this technique to speed up table load times,...

Notice how there is no 'I' in TEAM?

Furthermore, TEAM is not a word, it is actually an acronym. Simply standing for:

Together

Everyone

Achieves

More

So for those that hold onto knowledge exclusively, ask yourself...