homebrew01 (6/24/2009)

---

How many do you have ? (To...

Are you logged in with...

William,

The answer is yes, or no - depending on what is in your code 😀

Paul

Dynamic tally:

;WITHNumbers (N) AS

(

SELECTTOP (25000)

ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROMmaster.sys.columns

CROSS

JOINmaster.sys.columns C2

)

SELECT'A' + RIGHT((10000000000 + N), 9)

FROMNumbers;

Paul

The pipe character you are using as a terminator is also a batch script operator - you are effectively piping the result of the command to the statement after the...

Try setting the MAXERRORS parameter to the BULK INSERT statement - the default is 10 which means that the process only stops and reports after the tenth error.

Paul

I would encourage you...

Mike (6/24/2009)

---

I just wanted to point out that when moving to SQL 2008, this will no longer work. As per the BOL:

This feature will be removed in the next...

Mani,

You can move a table from one file-group to another by rebuilding the clustered index with the ON clause.

Non-clustered indexes work the same way but would have to be done...

Yeah I saw that 😉

A quick Google turned up this: http://sqlserverpedia.com/wiki/Stored_Procedures_-_Output_Parameters_&_Return_Values

The guarantee on the zero return value for success is in Books Online.

Paul

[font="Tahoma"]There are (currently) 99 different index maintenance scripts on this site already:

http://www.sqlservercentral.com/Scripts/Index+Management/[/font]

only4mithunc (6/24/2009)

---

K.. but select serverproperty will give the edition information only na? Like Enterprise/developer/ Standard/Express etc

And I think except Express edition others can be 32 or 64 , so only...

Andy Hughes (6/24/2009)

---

Thanks Paul, you've saved me some pain here

Undoubtedly I would eventually have had cause to experiment with this approach myself, but hadn't considered this limitation with the partitioned...

That's an interesting point of view 🙂

EdVassie (6/24/2009)

---

To me the key thing is that if the...

Fastest possible implementation:

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT 6 UNION ALL

SELECT 7 UNION ALL...