Viewing 15 posts - 436 through 450 (of 3,061 total)
JQAllen (2/29/2012)
March 12, 2012 at 12:39 pm
It all depends on data volatility and business requirements.
Two examples.
#1 - If you have a production database that gets updates once a day then setting that database to...
March 12, 2012 at 12:28 pm
You are correct, question is a bit generic and exposes very little backgroud on the specifications therefore is a bit hard to guess.
Either way, is this an OLTP system?
In the...
March 12, 2012 at 12:21 pm
marly (3/12/2012)
ColdCoffee (3/12/2012)
March 12, 2012 at 10:05 am
sufiyan.sarguroh (3/12/2012)
I want the tables uder db1 to be availaible in db2. Import/Export is one option. Can restore db also be used in...
March 12, 2012 at 5:36 am
MSQLDBA (3/10/2012)
After this result i increase the size of the database file, upto 2GB.
Did you increase the datafile size or did you allow SQL Server to extend datafile up to...
March 11, 2012 at 5:26 pm
I agree with Jared. Partitioning is not intended to be a solution for query performance but for data administration, like helping during archiving and purging processes.
March 7, 2012 at 3:29 pm
mupparaju78 (3/6/2012)
its take long time while run the query if we Don't have any data in table beetween date.
if we have data between dates.. got...
March 6, 2012 at 5:35 pm
robert.baird 2778 (2/28/2012)
March 3, 2012 at 1:52 pm
Make and unique index in such a column then handle the exception properly so to return a more polite message to the user - an alternative would be to do...
March 3, 2012 at 1:47 pm
Not sure if I got the specs right but, try this:
(ISNULL(DT_I4) ? "" : DT_I4) + (ISNULL(DepartmentID) ? "Unknown" : DepartmentID)
February 26, 2012 at 5:00 pm
Research Point-in-Time recovery which includes having the target database in Full Backup Model, taking both Full and Transaction Log backups.
Also check tail-log backup.
February 25, 2012 at 6:02 am
loki1049 (2/24/2012)
February 24, 2012 at 1:07 pm
GilaMonster (2/24/2012)
PaulB-TheOneAndOnly (2/24/2012)
Opus (2/24/2012)
February 24, 2012 at 11:25 am
Check execution plan ... is it taking advantage of index on SamplingDate column?
Are your performance statistics on base table up-to-date? if performance is decreasing as time goes by chances are...
February 24, 2012 at 11:22 am
Viewing 15 posts - 436 through 450 (of 3,061 total)