Something like this?  You'd have to test it for performance if you have thousands or millions of programs. I haven't done the concatenation to show 1/4, 2/4 and so on...

Murtaza

I would imagine that joining on such a wide column would cause performance problems, especially as your table gets to millions of rows instead of thousands.  Assuming you have a...

Prakash

As long as you're not replacing the C drive, and as long as the D drive only holds database files, I can't see any reason to reinstall the operating system.

The...

Try running the following query:

sp_MSenum_replication_agents @type = 3

This is what Enterprise Manager runs when you click on the Distribution Agents folder.  Does it return what you would expect?

John

MK

Which computer are you looking on - the Publisher, the Distributor or the Subscriber?

John

No need to cross-post.  Although this is the (more) appropriate forum, I've answered in the first place I found it, here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=284840

You need to reboot the server if you are modifying boot.ini.  Don't forget to change boot.ini on all cluster nodes.  I assume you are increasing memory on all cluster nodes?

Also,...

You can specify which tables go on which filegroup, so if your data files are in different filegroups from each other then you will be able to do what you're...

"JM - I think the params to the function would be customer and item, not Sold_Qty"

Tim

I haven't got a great deal of experience with functions, but if we make an...

Can you not use a GROUP BY to list all the customer/item combinations and a user-defined function to get the average of the latest five?  Something like this:

SELECT Customer, Item,...

Stewart

Yes, the folder needs to exist, and the account you use to start SQL Server needs read and write permissions on it.

I do not recommend backing up to a network...

Adam

You could create a job that writes a row to a table and runs whenever the text "Database backed up: Database MyDB" appears in the error log.

John

Arthur

Create a job to do the alerting (send a mail, FTP a file to your desktop, whatever) and, instead of scheduling it to run at a certain time, have it...

I take it you're referring to the TCP port on which SQL Server listens?  This information is stored in the registry, so you can use the reg add utility to...

Paul

I would stick with RAID1, even if you have logs from more than one database/instance on it.  The reason is that RAID5 is good for reads, but is slower for...