npranj | SQLServerCentral

npranj

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 17 total)

Topics

Posts

Last post
Combine overlapping datetime to return single overlapping range record

8 replies

6 years, 7 months ago

By: BradleyLeger
Export memo field to Excel truncates values

16 replies

7 years ago

By: WendellB
Avoid LEFT join

19 replies

10 years, 9 months ago

By: Gail Shaw
42% of 100% taken in clustered index insert

12 replies

11 years, 2 months ago

By: Grant Fritchey
SSIS Catalog using Transparent Data Encryption?

5 replies

11 years, 7 months ago

By: Koen Verbeeck
Pagination options SQL 2012 vs 2008 (Performance perspective)

2 replies

12 years, 6 months ago

By: gsc_dba
SELECT INTO vs INSERT INTO

3 replies

13 years ago

By: Orlando Colamatteo
Ideal table partition size per partition

4 replies

13 years ago

By: npranj
Remove blocking due to LCK_M_S and LCK_M_U

8 replies

13 years, 2 months ago

By: Gail Shaw
Performance using CTE vs temp tables

1 replies

13 years, 2 months ago

By: Jeff Moden
Inconsistent Reads after tuning the query

9 replies

13 years, 2 months ago

By: Gail Shaw
SQL Query: Subtract data from consecutive rows uptil non zero value reached.

8 replies

13 years, 3 months ago

By: npranj
Scalability of SQL Query

3 replies

13 years, 4 months ago

By: peterdru401
sql for building dynamic columns and rows from 2 tables.

2 replies

14 years, 10 months ago

By: npranj
Creating versions of records in tables

9 replies

14 years, 11 months ago

By: Grant Fritchey

Viewing 15 topics - 1 through 15 (of 17 total)