Viewing 15 posts - 2,596 through 2,610 (of 6,401 total)
has the drive been added as a dependency to the application group where SQL sits?
February 4, 2013 at 1:19 am
Remove the sets from your sp_send_dbmail call, also read the documentation on the procedure, it will tell you how to make a successful mail call.
February 4, 2013 at 12:58 am
Jeff Moden (2/1/2013)
anthony.green (2/1/2013)
ChrisM@Work (2/1/2013)
SELECT
T1.IDCUST,
T1.IDINVC,
T2.AMTPAYM,
TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)
FROM MyTable1_ARIBH T1
INNER JOIN MyTable2_ARTCP T2
ON T2.IDCUST = T1.IDCUST
AND T2.IDINVC =...
February 4, 2013 at 12:57 am
ChrisM@Work (2/1/2013)
SELECT
T1.IDCUST,
T1.IDINVC,
T2.AMTPAYM,
TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)
FROM MyTable1_ARIBH T1
INNER JOIN MyTable2_ARTCP T2
ON T2.IDCUST = T1.IDCUST
AND T2.IDINVC = T1.IDINVC
WHERE T1.IDCUST...
February 1, 2013 at 8:50 am
Convert the column before doing the ISNULL check
ISNULL(CONVERT(varchar, datecolumn),'')
February 1, 2013 at 8:19 am
You will need to convert the column to a string.
If you tell SQL to use '' as a datetime column you will get 1900-01-01 as that is the default date...
February 1, 2013 at 8:05 am
If your major focus is 2008, do the 2008 certs, if its 2012 do the 2012 certs.
While the exams are expired in July, your qualification doesnt expire with it if...
February 1, 2013 at 7:53 am
Something like this?
SELECT
T1.IDCUST,
T1.IDINVC,
T2.AMTPAYM,
Dev1.TotalPayment
FROM
MyTable1_ARIBH T1
INNER JOIN
MyTable2_ARTCP T2...
February 1, 2013 at 7:51 am
No. The backup is compressed, not the database, the data in the database still occupies 42GB its just the backup can be compressed due to factors in the compression...
February 1, 2013 at 6:12 am
If the log shipped but didn't restore, just issue a manual restore with standby / norecovery depending on the logshipping setup.
If a full backup has happened since the tlog deleted,...
February 1, 2013 at 5:13 am
If the FTC / FTI is already created, then the only way I know of to move it to a different file group is drop and recreate.
February 1, 2013 at 5:06 am
If it never grows more than 25gb dont set it to 50GB your wasting 25GB of space that will never be used. Set it to something like 30GB so...
February 1, 2013 at 4:59 am
Probably executed really quick as there was no free space in the files so there was nothing to shrink.
1. Not unless you created a full backup after changing to full...
February 1, 2013 at 4:53 am
When you create the full text index, use the option I detailed to tell it where to put it.
February 1, 2013 at 4:52 am
You can do it by going into the properties and changing the filesize of the files to something more sensible than leaving it a a stupidly small size that will...
February 1, 2013 at 4:48 am
Viewing 15 posts - 2,596 through 2,610 (of 6,401 total)