Viewing 15 posts - 48,001 through 48,015 (of 59,064 total)
Grant Fritchey (9/30/2008)
ruyfigueiredo (9/30/2008)
I have an database with 250MB and a Log File with 24GB.
After i reconfigure the Autogrowth i have...
September 30, 2008 at 7:48 pm
You bet. Thanks for the feedback. Just curious because other folks have had the problem of finding "Example E" and I'd like to be able to better direct...
September 30, 2008 at 7:43 pm
You bet. Thanks for the feedback. Does this mean you're all set?
September 30, 2008 at 7:40 pm
Mark... you showed the naming convention for the directories... what's the naming convention for the file names and extensions themselves?
September 30, 2008 at 7:39 pm
rbarryyoung (9/30/2008)
September 30, 2008 at 7:21 pm
You didn't copy the script correctly... you're comparing an Object_ID to a table Name in your from clause.
But, again, all that just isn't necessary. Look at my previous post.
September 30, 2008 at 7:15 pm
Ummm... ok... can you use xp_CmdShell or sp_OA* routines?
September 30, 2008 at 11:28 am
Just about anything that begins with "sp_" willl be checked for in Master first. I've known people to make Calendar and Tally tables that begin with sp_ just to...
September 30, 2008 at 6:16 am
Anirban Paul (9/30/2008)
I am not sure whether you could open the link provided by Jeff. You can try this:http://msdn.microsoft.com/en-us/library/aa174541(SQL.80).aspx
The link is a Books Online link... you need to copy and...
September 30, 2008 at 6:05 am
SQL Server uses a lot of "B-Tree" for this type of stuff... start at the following Books Online listing and drill down on the various types of indexes...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8936789a-e803-4814-83f2-77e717f81736.htm
September 30, 2008 at 5:39 am
Gail is correct, but just curious... you need more than 249 indexes on a single table? 😛
September 30, 2008 at 5:33 am
Dunno about anyone else, but I'm not seeing an SP...
September 30, 2008 at 5:29 am
Sorry for the delay...
Not everything that goes into TempDB has to begin with a "#" sign... you can use TempDB just like any other database. In other words, if...
September 30, 2008 at 4:49 am
I agree... call it "DBA" or "UTIL" or whatever... but avoid Master like the plague if you can. Just use the 3 part naming convention when you call it.
September 29, 2008 at 9:31 pm
Yep... but I need to know... do you expect that all of the file names are going to be in the same directory, or not?
September 29, 2008 at 9:22 pm
Viewing 15 posts - 48,001 through 48,015 (of 59,064 total)