Viewing 15 posts - 20,146 through 20,160 (of 39,834 total)
I don't think we have a big problem here as I don't find a lot of unanswered posts. We used to add a stock answer to a question after 24...
April 13, 2010 at 7:09 am
You can build an app for this, but I don't think Reporting Services will work with a table of users.
April 12, 2010 at 5:46 pm
T-Log backups is a good idea if you are getting lots of new data or changing new rows. If you have lots of changes to existing rows, you could have...
April 12, 2010 at 5:42 pm
The thing that we've done in the past is schedule a bunch of log backups during the import time. Then make sure that your imports are in smaller batches, not...
April 12, 2010 at 2:14 pm
It sounds like you have an extremely large db. The diff should be fine, but keep in mind that without more full backups, you are risking data loss if something...
April 12, 2010 at 2:07 pm
There are some good reporting services articles here on the Site that implement some of the features that you get with Enterprise with Standard. They might help you with the...
April 12, 2010 at 1:40 pm
Tammy,
We aren't typically annoyed by beginner questions. Even silly ones, but what does get to be "worse" in our minds is the people that don't make an effort. Someone that...
April 12, 2010 at 1:37 pm
Litespeed and SQL Backup allow you to trade off compression for time/resources as well, with different levels. The native SQL 2008 compression is on/off only.
April 12, 2010 at 1:05 pm
Here, I'll give you a head start: http://technet.microsoft.com/en-us/library/bb522534.aspx
April 12, 2010 at 12:59 pm
I don't want high performance children. Heck, I need something to hold over them! They can be high performing adults, when I will need them to take care of me...
April 12, 2010 at 12:58 pm
In terms of cost, you would have to research your situation. 2008 was the same cost as 2005, but 2008 R2 has a price increase.
Why do you want to upgrade?...
April 12, 2010 at 11:58 am
If the issue is finding space, then separate filegroups will definitely help. Just didn't want you to think that you could easily piecemeal restore. You can do some filegroup restores,...
April 12, 2010 at 11:52 am
It mentions permissions. Your linked server is working, but perhaps that package/module is not one you have rights to call.
April 12, 2010 at 11:39 am
I believe that autogrow does require a lock on the files, but it should be part of SQL Server. I'm not sure what you mean by file in use here...
April 12, 2010 at 11:39 am
Lowell is correct. You are converting this to a number in this table, and by convention, numbers do not include leading, or trailing zeros after the decimal.
April 12, 2010 at 11:36 am
Viewing 15 posts - 20,146 through 20,160 (of 39,834 total)