Viewing 15 posts - 16 through 30 (of 77 total)
The bug listed in the KB article does not affect 2008 R2, at least according to the article.
September 13, 2012 at 12:30 pm
nagkarjun1 (9/13/2012)
How to know the current settings for a server for the following:Page file Size should be 1.5 to 2 times the actual RAM
Some of these are certainly debatable. ...
September 13, 2012 at 12:08 pm
There is not a "requirement" for clustered indexes to auto increment. This is suggested for actual tables since having an incrementing key (such as an identity or datetime) reduces...
September 13, 2012 at 9:59 am
Divide your sum by the CountRows() function
September 4, 2012 at 5:50 am
SELECT ISNULL(T1.paytoname, T2.paytoname) paytoname,
ISNULL(T1.pname, T2.pname) pname,
ISNULL(contract1,'') contract1,
contract2,
ISNULL(Memcount1,0) Memcount1,
Memcount2,
Pcount,
ISNULL(Paid1,0) Paid1,
Paid2,
ISNULL(plans1,'') plans1,
plans2
FROM #table2 T2
LEFT JOIN #table1 T1 ON T2.paytoname = T1.paytoname
August 30, 2012 at 12:34 pm
I think dm_db_partition_stats is what you want. Change the index_id depending on if the table is clustered or a heap.
SELECT so.name,
ps.used_page_count * 8 AS UsedKB,
ps.reserved_page_count * 8 AS ReservedKB
FROM...
August 30, 2012 at 11:17 am
allmhuran (8/29/2012)
...Now assume we want to have our sales (rentals) fact table showing invoice revenue at the granularity of product, branch, and financial period.
...
I think you need to...
August 29, 2012 at 6:26 am
Think about how you can build select statements to return the data in sets instead of using nested loops. The goal is to do operations on columns of data...
August 15, 2012 at 8:19 am
August 1, 2012 at 12:02 pm
There should be an SSIS menu. Variables should be available from there.
August 1, 2012 at 11:12 am
Take a look at the substring function
/*
A1234 will become A12.34
B98765 will become B98.765
*/
DECLARE @String1 VARCHAR(10)
DECLARE @String2 VARCHAR(10)
SELECT @String1 = 'A1234',
@String2 = 'B98765'
SELECT SUBSTRING(@String1,1,3) + '.' + SUBSTRING(@String1,4,LEN(@String1)-3),
SUBSTRING(@String2,1,3) + '.' +...
July 18, 2012 at 5:11 am
This is a "feature". If you look in the report project folder you'll see a file with <name of your report>.rdl.data. Deleting this file will delete your data...
July 6, 2012 at 11:34 am
This will be part of the Tablix properties. Set the RepeatColumnHeaders property to True.
July 5, 2012 at 11:25 am
It looks like you could use a Left Anti-Semi Join and bypass the merge completely. Untested code below.
INSERT INTO Policy.PolicyRiskUnit
FROM ( SELECT NULL AS 'PolicyRiskUnitTrID' ,
...
June 20, 2012 at 8:53 am
Viewing 15 posts - 16 through 30 (of 77 total)