SELECT ID, DocContent

FROM...

The best way is to query the known partition by restricting it. The database engine will take care of knowing where to look. So If mine is partitioned on month,...

Marius.D (6/4/2012)

---

Sorry for posting like that, I was only looking for some advice, direction, not a 100% solution. Both tables, A and B, have hundreds of columns. I cannot provide...

Here is a script that I use, though I can't find the reference to it so I cannot give credit. However, I did not write it:

select

obj.name ...

What do you mean by "no longer hardcoding... an alias should be used." ? Not sure that hardcoding is really really related to an alias... An alias still can be...

What exactly are you trying to do? Count the number of rows contained in a specific partition?

Marius.D (6/4/2012)

---

I have a stored procedure which runs anywhere from 1/2 minute to 4 hours (during nightly processing):

UPDATE tableA

SET tableA.Other_Flag_50=isnull(Staging.other_flag_50,0)

FROM tableA INNER JOIN

(select...

river1 (6/4/2012)

---

I made like this:

SET @SQLString = 'select @maxVal = isnull(max(cod_sincronismo_fim),0)

...

One thing I can see being a potential problem is that the database user and the login are not synced. When you restore from 2000 to 2008, the id...

Change the SP or create a new one.

It doesn't make sense what you are doing. Why are you trying to use dynamic SQL when there is nothing dynamic there?

Just do this:

set @MaxTotalidade = select convert(bigint,isnull(max(cod_sincronismo_fim),0))

from SGCTCentral.dbo.sincronismo

where...

Sorry... Clicked send before I pasted it 🙂

http://msdn.microsoft.com/en-us/library/ms143550%28v=SQL.110%29.aspx

Well... As a final update I have found that it will in fact be removed later on an MS site.

Does anyone know if the feature is mentioned my MS as deprecated, or was this just noticed by some in the Wizard? I cannot find any actual MS documentation on...

pveilleux (5/31/2012)

---

Good point. I have always done a reboot to be on the safe side. This client has many, many, many processes that move data among multiple...