Nicely done, Adrian...

The big advantage of creating file groups on different disks is purely physical... you get more read write heads involved.  Of course, the same could be said for partitioning one...

You could also make a batch job that runs a "SELECT" via OSQL to create a CSV file as the output.... Windows Task Scheduler takes care of the rest...

Great suggestion.  Old gaming trick... if you can't move, "change color".

Ditto on the nulls...

CREATE PROCEDURE [dbo].[SEQVAL] @tblname varchar(100) AS

Begin tran

UPDATE CASE_NUM_SEQ SET CURRVALUE = CURRVALUE + INCR WHERE SEQ_CD = @tblname

SELECT CURRVALUE FROM CASE_NUM_SEQ WHERE SEQ_CD = @tblname

commit

We had a similar procedure at work (created by a 3rd...

Heh... "for reference only"... just wait until they ask "how many logins this week"... and they will...

Anyway, thanks for the feedback, Charlie.

Cross post

Cross post

You've certainly got CROSS-POSTING down pat!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=361685

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=361683

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=361682

Download one of the lite versions of SQL or MSDE... they're free...

I'm not sure what they did, but our DBA's setup a system of alerts that sends them email on their "crack berry" if a CPU spikes for more than a minute or...

Sreemati,

Most of the suggestions folks have given so far in this thread are spot on...

I'd like to add that you must change your thinking, as well.  You must stop...

Rudy, where's that list you and I came up with many moons ago?  I think step #1 was something like "Write good set based code"...

Charlie...

Dunno if you can do anything about it, but it's "Death by SQL" to store dates and time as NVARCHAR (ESPECIALLY WITH THE DAY OF THE BLOODY WEEK!!) instead of...

You could put a trigger trigger on the table that counts the rows in the table... could be either an AFTER trigger that deletes what's been inserted once it hits...