Viewing 15 posts - 33,796 through 33,810 (of 39,736 total)
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
I disagre, the question states that there is "contention". It says:
you have a number of databases making heavy use of tempdb on your SQL Server 2000 server, which is...
August 2, 2005 at 12:26 pm
I think there are definitely some great leaders and those that build companies. But lots of business is luck, it's timing, it's taking advantage or being able to take advantage,...
August 2, 2005 at 10:45 am
I'm a little torn here. A SQL Server 2000 instance is an instance of a database server. Maybe it's semantics, but each instance is a server. The confusion above seems...
August 2, 2005 at 10:39 am
I think it's a great question. If you are presented with any question in an interview it won't be with a complete understanding of the situation. That's why you ask...
August 1, 2005 at 10:28 am
It's a bug, but we're rewriting the aritcle stuff, so be patient.
August 1, 2005 at 10:26 am
It appears from my testing, that if a create table is in the sproc, the grant execute does indeed create those permissions. I setup a simple sproc to create a...
August 1, 2005 at 10:25 am
You only need the SP for the SQL Server for the base product. The MSDE one is for MSDE installations only. The AS one is for the Analysis Services product...
August 1, 2005 at 9:10 am
Viewing 15 posts - 33,796 through 33,810 (of 39,736 total)