Partitioning is an ADVANCED and COMPLEX feature that was never built in the first place for performance - it was primarily for improving ETL and maintenance. I HIGHLY recommend...

Anamika (1/15/2012)

---

hi,

Does Table Value function caches execution plan?

one of my query is performing slow for the first time. i can't put this query in stored proc as it is...

I can see both sides to this coin, and really don't know the best answer. If Steve can come up with a system like he described (using the D&D...

roasdasdb 89asdasdasd013 (1/12/2012)

---

Sounds like you are expecting the data files to automaticallly shrink, which does not happen unless explicitly set at the database level or requested on an ad-hoc bases.

Try...

Anonymous, you have been given GREAT ADVICE by two of the best here and it goes to a FUNDAMENTAL DIFFERENCE between Oracle and SQL Server. To be effective/efficient with...

You cannot do this. But like Gail I...

Definitely need more information on your actual NEED here to be able to guide you effectively.

Note that which database is taking up buffer pool space can change drastically from minute to minute. I can run one big report-style query and flush just about everything...

1) It isn't just gold partners that can't design/build a decent SQL Server application. Have you ever taken a gander at Sharepoint?? :w00t:

2) Many 3rd party vendors have cross-platform...

1) why do you want to know the various internal memory consumption? There is almost nothing you can do about it, and the knowledge is VERY unlikely to help...

Steve Jones - SSC Editor (1/5/2012)

---

We're not going to explain in detail the steps that are needed for your very large database. You need to learn how to do it.

How?...

DANGIT!! I usually check for that but the combination of a stressful work day combined with about 2 hours of sleep...

Jeff Moden (1/5/2012)

---

Heh... my Grand Father gave me...

xaeru (1/6/2012)

---

Dave Ballantyne (1/4/2012)

---

TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.

If you are going for a DBA...

Just in case you want to scale this out in the future to have multiple "queue-poppers" note that you can use the READPAST hint to allow the queue SELECT statement...