Viewing 15 posts - 4,336 through 4,350 (of 6,679 total)
For me - the easiest method is using SQL Compare from redgate. You can download a fully functional trial version to test it out. Since I use this...
December 30, 2009 at 1:04 pm
I have to say - I didn't even think I had suggested changing the actual column to a date data type. If it came across that way - I'm...
December 29, 2009 at 6:48 pm
Right-click on the database, select Reports | Standard Reports | Disk Usage by Tables
December 29, 2009 at 6:45 pm
You can start by running the standard Disk Usage by Tables report. This report will not give you columns for the table - but gives you everything else you...
December 29, 2009 at 3:51 pm
Jonathan Turlington (12/29/2009)
An alternative to what I...
December 29, 2009 at 3:41 pm
You reset it to 100MB from what? If the last time it autogrew was back on the 15th - then the only other option is that someone manually grew...
December 29, 2009 at 3:37 pm
BSavoie (12/29/2009)
CREATE INDEX MyIndex ON...
December 29, 2009 at 3:35 pm
GilaMonster (12/29/2009)
Check with whoever's responsible for the backups and ask whether or not there are any differential backups been run. If there are, to avoid messing up the recovery...
December 29, 2009 at 2:41 pm
In the following article: http://msdn.microsoft.com/en-us/library/ms188783(SQL.90).aspx under the heading 'Required SET Options for Indexed Views' it clearly shows what values need to be defined when creating an indexed view.
There is also...
December 29, 2009 at 2:31 pm
What is the autogrowth setting for that database now? Review the standard report for Disk Usage which will include a record of all autogrowth events since the last time...
December 29, 2009 at 2:16 pm
There is no native utility for restoring a single table. If you were using a third-party backup utility, that utility might have that capability.
The only way to do this...
December 28, 2009 at 8:09 pm
Check the SQL Server logs to find out if the instance has been restarted. It might be a situation where the system crashed and it is taking a long...
December 28, 2009 at 8:07 pm
Steve Jones - Editor (12/28/2009)
Typically you would do this:
select *from sales
where datesvc >= '9/1/2009'
and datesvc < '10/1/2009'
To expand on what Steve is showing here, you...
December 28, 2009 at 8:05 pm
As far as I know - SQL Server does not support databases on encrypted volumes using Truecrypt. I would bet that is the cause for your problems.
I still don't...
December 28, 2009 at 7:02 am
Is this a named instance on your local PC? If so, what is the name of the instance and how are you trying to connect?
December 25, 2009 at 9:25 am
Viewing 15 posts - 4,336 through 4,350 (of 6,679 total)