The first thing that you need to do is to answer this question: "Is everything generally slow? Or is it one specific thing or a group of related...

You can use the...

Nice explanation, Peso.

Of course, in this example you are assuming that the first record is easy to identify, but even that is not necessarily so.

I don't think that any of us in this discussion (so far) have any problems with MVP's or the MVP program Robert. Steve is an MVP and some of...

sigh* Please note which forum you are in.

Just post the text version then.

If so, it would almost certainly be in Analysis Services, not Integration Services.

Lowell (4/9/2009)

---

here's my version, where i figured i'd find and replace from an existing set of commands i know works fine:

i greated a login named 'bob' with connect priviledges. this...

HVPR (4/9/2009)

---

Thanks for your suggestions..

and sorry for the posting twice...

But I want to know is there any local sql server feature or tool which can help to sync the

code between...

BWAWAHAHA!!! :laugh:

Manie Verster (4/9/2009)

---

I would like to take your query further and add dependencies to it because I see a few tables that looks like they might have been created as...

AFAIK, "~TMPCLPnnnnnn" is the name of an MS-ACCESS temporary table. I have no idea what one would be doing in a SQL Server database.

Lynn Pettis (4/9/2009)

---

RBarryYoung (4/8/2009)

---

EdVassie (4/8/2009)

---

This would show to new users to SQLServerCentral that advice given by an MVP is potentially correct and they should take notice of what is said....

Heh. ...

Didn't we do set-based prime sieves last year sometime? ...

Format 121 solves all problems!:

Select Right(Convert(varchar(16), getdate(), 121),5)