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

😎

Echoing Jeff´s question and adding some more, are you using a single file tempdb configuration? Do you know what is causing the growth? Are you experiencing any congestion in the...

Quick suggestion (pseudo code)

😎

DECLARE @ParamTable varchar(100) = N''; -- include schema, error...

KGJ-Dev (12/4/2014)

---

Hi Erik,

as i don't want to open a new post for this, as we have all the information on this post, i would like to extend this conversation.

I am...

No shredding, just minor improvement

😎

First a data set

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @DUMBER_OF_CLUBS INT = 200;

IF OBJECT_ID('dbo.TBL_CLUB') IS NOT...

Herpington_McDerpington (12/3/2014)

---

Eirikur Eiriksson (12/3/2014)

---

Quick questions, what is the data source (ORA Version)? Have you tried using ALTER SESSION SET NLS_DATE_FORMAT to "format" the output of CURRENT_DATE? Don't think it's...

Herpington_McDerpington (12/3/2014)

---

Hello all, I'm not really sure what level of expertise folks may have in the ODBC realm here. If there's a more appropriate category on the forum please let...

Steve Jones - SSC Editor (12/3/2014)

---

Don't knock LinkedIn too much. It's networking, which is incredibly valuable if you need employment or want to move. Many of you have used networking...