Viewing 15 posts - 29,926 through 29,940 (of 39,769 total)
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
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...
January 9, 2008 at 9:47 pm
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.
January 9, 2008 at 3:09 pm
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...
January 9, 2008 at 10:43 am
select a.first_name, b.last_name
from table a, table b
order by new_id()
January 9, 2008 at 8:06 am
Viewing 15 posts - 29,926 through 29,940 (of 39,769 total)