Viewing 15 posts - 4,816 through 4,830 (of 7,185 total)
Yes, that's right. But of course once it's consumed or reduced, it's closer to 0% than to 40 or 99.
John
January 10, 2012 at 6:40 am
Free space isn't relevant since autogrow is what happens when the free space runs out. It doesn't force any space to be used. 1% is probably rather low,...
January 10, 2012 at 6:22 am
Probably best to monitor file size proactively but set autogrowth just in case. The fragmentation levels I've seen used most often are to reorganise indexes above 5% and rebuild...
January 10, 2012 at 6:05 am
Why would there be a difference from BritishEnglish to English?
Because it can cause the value of DATEFIRST to be different, which is what your CASE expresssion relies on.
Have a read...
January 10, 2012 at 2:59 am
I would guess this is caused by a difference in the local settings for each user - you and the user that connections to the linked server are made as....
January 9, 2012 at 8:57 am
Yes, maintenance plans will do that for you. You don't have any control, as far as I know, over the actual name of the file, but you'll get each...
January 9, 2012 at 7:19 am
I'm sure you've already typed "protect database backup with password" into your favourite search engine, and that you noticed that the top result was Microsoft's MSDN page Security Considerations for...
January 9, 2012 at 4:09 am
If you change to int, what's to stop invalid dates such as 13132011 getting into your data? Also, if you index on integers like that, you're not going to...
January 9, 2012 at 3:45 am
You can answer that one yourself. Use the DATEPART function again. If you don't know the syntax, you'll find it in Books Online or on the web.
John
January 6, 2012 at 4:24 am
Dan
I feel your pain. If you don't have the option to change the database, do you have the option to change the application? That way, you could perform...
January 6, 2012 at 4:22 am
But it won't look for the database name on the other server - that's the whole point. If you don't know the database name then you can't do anything....
January 4, 2012 at 4:31 am
That won't work. Why do you want to build your SQL statement dynamically? It's the same statement you're going to execute no matter what environment you're in. ...
January 4, 2012 at 4:16 am
Well, if you don't know the database name, you're stuck. Can you not just ask the owner of the server? Once you find out the name of the...
January 4, 2012 at 3:57 am
How is the database name determined? If you're always passing in the same name, that doesn't sound very dynamic. Maybe what you need is to use Package Configurations...
January 4, 2012 at 3:35 am
Viewing 15 posts - 4,816 through 4,830 (of 7,185 total)