Remember this next time you complain about your politicians. 😉

SQL Kiwi (1/10/2012)

---

The site is usually pretty good at handling spam reports so my personal view is we don't need moderators, in general. Judging from an automated out-of-office email...

GilaMonster (1/10/2012)

---

Ninja's_RGR'us (1/10/2012)

---

Gianluca Sartori (1/10/2012)

---

mtillman-921105 (1/9/2012)

---

I've been interested in that too......

I don't think there's a baked answer to this question.

"As many as your hardware can handle" would be quite close.

If your server has adequate memory, CPU and disk to serve...

mtillman-921105 (1/9/2012)

---

I've been interested in that too... Is Einstein wrong?...

There's an article here[/url] that describes how to extract the cached plans that contain missing indexes information. Doesn't do exactly what you're after, but could get you started.

Hope this helps

Gianluca

Very annoying. I think the random words are meant to trick search engines.

I don't know which countermeasures can be taken, if any. I would be extremely upset if I had...

Did anyone else notice an unusual spam flood these days?

Also, spammers seem to have changed strategy now and they add replies to existing threads instead of starting new ones.

edit: fixed...

No, that's resuscitating...

No way, AFAIK.

You could do that with dynamic sql:

CREATE PROCEDURE mysproc

AS

BEGIN

EXEC ('select * from myserver.mydb.dbo.mytable')

Not exactly what you're after, but could work. Another possible solution is creating a loopback linked...

Why re-invent the wheel? Adam Machanic wrote a great piece of code known as "sp_WhoIsActive", that will tell you this and much more. Give it a try!

This should do:

WITH SampleData (seconds) AS (

SELECT 1

UNION ALL

SELECT 110

UNION ALL

SELECT 65

)

SELECT roundedUpSeconds = 60 * CEILING(CAST(seconds AS decimal(18,6)) / 60)

FROM SampleData

Hope this helps

Gianluca

anonymous2009 (1/9/2012)

---

Question 1:

I'm wondering if the select from the table variable "SELECT @Count = tabl_var_Count FROM @tab_var WHERE tab_var_Id = 1" could be avoided and instead something could be...

You could use sqlio to benchmark the drives.

Here is a video tutorial by Brent Ozar that should help you understand how to use the tool.

Hope this helps

Gianluca

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything...