I would seriously look into using an Identity column and partitioning the table based on the year. That'll be the easiest and most robust solution. If you do...

No. Additional pages usually just means it won't fragment as rapidly next time. Should have just about zero impact on selects and deletes, and might improve the speed...

I could be mistaken, but it looks to me like this part:

DECLARE @my_count int, @client_id varchar(10)

SET @my_count = @@ROWCOUNT

SET NOCOUNT ON

/* ------------------------------------------------------------------------------ */

ONE_MORE_TIME:

IF (@my_count > 0)

GOTO START_ONE_MORE_TIME

ELSE

GOTO ALL_DONE

Will...

scsfdev (8/23/2009)

---

Hi all,

Can someone tell me

1. which T-SQL keywords use more time than others? I want to know the list.

2. If you have any links for this, please share me.

Currently,...

I like the idea of a stripped down version of Windows for this purpose more than the idea of SQL Server having to support hardware drivers, Active Directory, booting, internet...

To those who have checked the suggestion out, "thank you".

The more the merrier, so if anyone else can head that way and vote on it, it would be appreciated.

You're welcome.

ALTER DATABASE dbname MODIFY FILE ( NAME = currentname, NEWNAME = newname )

All that kind of stuff comes under Alter Database in Books Online.

RBarryYoung (8/25/2009)

---

Pretty cranky, to be honest.

My sixth day in the hospital, I'll get transferred to rehab tomorrow. The back/leg pain has been gone for 4 days, but my right...

If you store the XML as varchar(max) instead of as XML, you could use Replace to add line-breaks after certain tags. Would that do what you need?

Command-line plus Windows scheduler is the simplest and doesn't cost anything.

xp_readerrorlog is the main way that gets done. It's an undocumented, unsupported method, but it's what's most common.

I've put in a request to Microsoft to document it or support...

You mentioned a linked server. Network traffic might make a difference. Lots of things might. Have you tried tracking CPU, memory and I/O use during the job?

You'd have to use the Current Security Context option. Or explictly list the logins in the top half of the window.

Login mapping is the first thing that comes to my mind.

Do you have a "Use this login when ..." set up in the security for the linked server?