Viewing 15 posts - 33,856 through 33,870 (of 39,803 total)
You might try, if you can, removing and reinstalling the client tools. I'm sure something got mucked up in the install. My XP SP2 worked fine with SP4, but I...
August 4, 2005 at 10:43 am
I guess the cursor thing is possible, but I haven't seen that to be an issue. I thought that cursors would grab a copy of the data to hold it,...
August 4, 2005 at 10:41 am
If you have a firewall nearby, you might be able to do some port redirection if needed.
August 4, 2005 at 10:40 am
Throw - "Can't you just throw all that data onto a report?"
August 4, 2005 at 10:33 am
Dreams are great, but you need to ask. Next time you get a review or an interview, ask for a bit more and see what happens.
August 4, 2005 at 10:32 am
Anytime and thanks for the update.
Did you script them out? Just checking in case someone else searches the thread.
August 3, 2005 at 12:58 pm
Use dynamic SQL to build a string based on the other table, then exec() it.
August 3, 2005 at 10:32 am
Use the @attachments parameter. The files need to be on the local disk drive of the SQL Server.
August 3, 2005 at 10:31 am
I believe master can only be put into single user mode with the startup parameter.
August 3, 2005 at 10:30 am
What's the growth parameter? 10%? Is 10% > 63G?
That might be it. The other issue could be that that particular file in a filegroup is full, but the other files...
August 3, 2005 at 10:27 am
No good way. That's what the constraints are there for. You can script them out and drop them, reload, then recreate them.
August 3, 2005 at 10:26 am
As someone that's had about 20 interviews in the last 6 years, I can tell you that I've seen DBA salaries as low as 65k and as high as 95k...
August 3, 2005 at 10:25 am
All 4 answers are definitely not correct. Each database instance DOES NOT have it's own tempdb. Each database on a SQL Server shares one tempdb. There can be multiple instances...
August 2, 2005 at 10:15 pm
What everyone has presented is valid. However the question wasn't "how do I solve this", it was a "identify the problem". tempdb being shared is the problem, the solution could...
August 2, 2005 at 12:52 pm
Viewing 15 posts - 33,856 through 33,870 (of 39,803 total)