J (10/2/2008)

---

"'dbo.selectthisandthat"

For my taste, I find this harder to read (mid-50 eyesight and all), it requires more attention to figure out the meaning of the name. I feel something is...

Kenneth Wilhelmsson (10/2/2008)

---

This is really another subject, but I feel I have to disagree anyway.

What you're essentially proposing here, is that the model doesn't count.

Whenever you're using 'select *' instead...

Christo Wolmarans (10/2/2008)

---

No worries.

Would it be possible in SSIS to get the server name using an SQL task and then assigning it to a variable in SSIS which can then...

Go for the big egos. Nobody likes to be shown up for writing dross, as well as the profiler log, you could also highlight where pulling shedloads of rubbish...

GSquared (10/1/2008)

---

I'm curious, I must admit, about the connection between the title and the actual post. What do missing records have to do with performance tuning? Same for...

pavankumar.mvs (10/1/2008)

---

Hi

I am new to sql server 2005. I have few questions to the forum, Please give me the solutions.

1). My database is running fine all...

Sorry Christo - didn't make it clear that I was replying to the original poster to try and narrow down his requirements. I'm assuming that as it's posted in...

Hi,

are you talking about doing this as part of an SSIS package?

Anders Pedersen (9/29/2008)

---

True. It can, it can also happen a lot sooner than that. Point is to break it up into chunks that would not impact business. ...

10, 000 records will escalate to a table lock

If you're going for the straight delete - make sure you're doing it 'out of hours' as this is going to tablelock until the delete's complete - which could be...

Particularly odd given...

Could be, especially if your environment is one where a lot of passthrough queries are sent to the system and these sp's are not run that often, that they're getting...

Permissions

WHen you go to the report concerned - does the second tab from left say properties?

If not, you'll need to get your permissions upgraded.

If so, click on that tab -...