How can you do this in T-SQL? The time to open a connection comes from when the client starts trying. The server has no idea of this time if there...

There's probably an elegant way, but I'd write a cursor to print each value, then when the error occurs, look for the next value.

Do you mean this?

http://msdn2.microsoft.com/en-us/library/ms178569.aspx

Nope, bug on the part of the company that built these forums.

I think they intended the sig to be a one liner. I've logged this.

If you want to know, politely ask the company. Usually someone will tell you that they found another candidate that had more experience, but sometimes they might give you a...

Tobi,

I think the splitting is what happens and you get half and half over time. Most people that want to split things, use separate filegroups, say one for data (clustered...

You'd like to think we're preaching to the converted, but what I've found over the years is that many people who read stuff here don't respond, especially if they're new.

As...

I'm kind of clumsy, hard to walk a straight line. Occassionally gets me into trouble on Friday nights...

We definitely try to be THE SQL Server site you go to first...

I'm not sure a primary key is ummutable. If you had a taxID that changed (corporate sale, etc), then it could change, but it must remain unique.

I use mixed case, like

create table MyTableForSales

Get a CPA, and you can deduct their fees on taxes.

make sure you keep track of all expenses in writing. And plan on filing quarterly taxes. Guess what you would...

I tend to agree with Matt, pick what makes sense for you.

Heck, if you're getting reimbursement, go for both. An MBA with concentration in MIS probably gets you a long...

It just runs sp_delete_backuphistory.

You can profile it, but the easiest thing to do is hit the View T-SQL button on the task. It shows you what runs.

Me, too. I'll grab my resume, err coat and meet you downstairs 🙂

It pays to test your restores regularly, but I'm not sure I'd test everyone. The SQL backup to...

select a.first_name, b.last_name

from table a, table b

order by new_id()