Viewing 15 posts - 22,846 through 22,860 (of 39,824 total)
Do all procedures get marker or only those from the dependency tree in SQL Server get marked? I assume this is at the end of each index that is rebuilt?
August 3, 2009 at 1:21 pm
The service account needs permissions to create the database, not your log in account.
August 3, 2009 at 12:44 pm
you'll have to ask Red Gate, but Eugene isn't too far away. Might be a nice trip. Spent some time there in 98 and enjoyed it.
August 3, 2009 at 10:59 am
you can't drop them all at once. You can loop across the result set (while or cursor) and issue a DROP USER for each one.
The same thing occurs for the...
August 3, 2009 at 9:59 am
You have 6 filegroups, not 1. So the way it works is that your files in that filegroup take the data for the tables stored there. If they run out...
August 3, 2009 at 9:54 am
you must have an object on that particular filegroup that is growing. As mentioned, a table doesn't grow across filegroups.
August 3, 2009 at 9:39 am
Interesting you mention cooking. 37 signals talks about inspirations from chef's and recently Andy Warren started cooking a bit and said it gave him an interesting perspective. Perhaps that should...
August 3, 2009 at 8:50 am
Lynn,
Best wishes, and I hope it goes well. I'm sure she will appreciate the hardships later.
August 3, 2009 at 8:40 am
Ok, double check what you're saying.
It is one physical file split into many physical files? either you have one MDF, which is one file, one file group, or you have...
August 3, 2009 at 8:36 am
Jeff, there are a few MI people that do SQL. you ought to get the user group to run a SQL Saturday. The event in Baton Rouge ran smoothly, minimal...
August 3, 2009 at 8:19 am
Sarah B (7/31/2009)
August 3, 2009 at 8:14 am
jpowers (7/31/2009)
August 3, 2009 at 8:12 am
Terri (7/31/2009)
August 3, 2009 at 8:10 am
It uses the reserved space automatically.
Let me ask a couple questions. Are you giving us total space or data space? Some people confuse the log with the data, and see...
August 3, 2009 at 8:08 am
Viewing 15 posts - 22,846 through 22,860 (of 39,824 total)