Enjoy! and Happy Pongal!

No, the engine has to know where to put the pages.

Restore as one file, then create new filegroups and files and move the data (by recreating clustered indexes) in the...

1 - assign the users the db_backupoperator rights

2 - It can. If the Windows group has been granted the sysadmin role, they do. This is set up by default, but...

You could just need that much tempdb space. It all depends on your queries. It's used for sorting, etc.

You can shrink it down, but it could grow right back...

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...