+1

😎

Window function version of Alvin's code

😎

SELECT

State

,ZipCode

,Count(Account) OVER

(

PARTITION...

Quick solution, counts the spaces after "cleaning" to determin whether there is a format present

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH BASE_CLEANING AS

(

SELECT

...

Quick thought, on a 32 bit version of SQL Server there are severe restrictions not applicable to the 64bit version, even more true with 2012/2014 where the AWE support has...

Siva Ramasamy (12/6/2014)

---

Dear SQL enthusiasts/experts,

Thanks for your interest in my question.

I have recently inherited the administration responsibilities of a production database (SQL 2012) (around 350GB).

It only had one...

The first thought on this problem is not the addition of a column but the design itself, which prompts questions on the role of the table, the practice of adding...

BTW the 2014 cardinality estimator goes on a hike on this one, with only handful of rows in the set it estimates 16.4317 rows for both queries, in fact the...

Bullseye...

Good stuff, now we are getting somewhere;-)

The data/index ratio is the ratio between the raw data and the duplication of data...

Quick suggestion

😎

SELECT

PT.idx

,PT.paymentDte

,PT.officialReceiptNo

,PT.sysReceiptNo

FROM dbo.paymentTrnx PT

WHERE (YEAR(PT.paymentDte) * 100) + MONTH(PT.paymentDte) BETWEEN 201201 AND 201203;

Tac11 (12/7/2014)

---

I have 3 data files on my database.

1. .mdf is 300 gb.

2. .ndf is 250 gb

3. .ndf is 75 gb

all have less than 10% space available. I read...

Here is a very simple way of constructing a html table in T-SQL with the background definition you asked for

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @HTMLSTR VARCHAR(MAX) = '';

DECLARE @SAMPLE TABLE

(

...

Here is a code snip that should help you get passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Never trust the defaults 😉 */

SET DATEFORMAT 'mdy';

DECLARE @TDATE TABLE (TDSTR VARCHAR(25) NOT NULL);

INSERT...

Quick thought, sum the addition of all columns

😎

SELECT

SUM(TS.COL_001 + TS.COL_002 + TS.COL_003 + TS.COL_004 + TS.COL_005 + TS.COL_006 + TS.COL_007 + TS.COL_008 + TS.COL_009 +...

Quick thought, use trace flags 1117 and 1118

😎