Viewing 15 posts - 29,971 through 29,985 (of 39,818 total)
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...
January 11, 2008 at 7:45 am
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...
January 11, 2008 at 7:44 am
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...
January 10, 2008 at 9:17 am
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...
January 10, 2008 at 9:15 am
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.
January 10, 2008 at 9:14 am
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.
January 10, 2008 at 6:40 am
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...
January 10, 2008 at 6:40 am
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...
January 10, 2008 at 6:37 am
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...
January 10, 2008 at 6:16 am
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...
January 10, 2008 at 6:12 am
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.
January 9, 2008 at 9:53 pm
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...
January 9, 2008 at 9:49 pm
Viewing 15 posts - 29,971 through 29,985 (of 39,818 total)