Viewing 15 posts - 4,816 through 4,830 (of 7,187 total)
Unrestricted file growth will depend on whether your database shares the disk with other databases that may also want to grow. If it does, then it's wise to set...
January 10, 2012 at 7:25 am
What is the relationship between the data in table1, table2 and table3? You can't just put some columns from one table and some from another in the same row...
January 10, 2012 at 7:10 am
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
Viewing 15 posts - 4,816 through 4,830 (of 7,187 total)