SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content by Thomas Franz

SQLServerCentral.com profile

   Items 1 to 17 of 17   
 

IDENTITY_INSERT

By Thomas Franz 2019/02/11 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 712 reads

REPLACE and NULLs

By Thomas Franz 2019/01/04 | Category: replace()
Rating: (not yet rated) |  Discuss |   Briefcase | 905 reads

sp_rename and stored procedures

By Thomas Franz 2018/09/24 | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 739 reads

CASTING Binary to BIGINT

By Thomas Franz 2018/10/12 | Category: cast
Rating: (not yet rated) |  Discuss |   Briefcase | 913 reads

UNION and Duplicate values

By Thomas Franz 2018/06/12 | Category: union
Rating: (not yet rated) |  Discuss |   Briefcase | 1,033 reads

Performance of GROUP BY multiple columns

By Thomas Franz 2018/03/27 | Category: group by
Rating: (not yet rated) |  Discuss |   Briefcase | 971 reads

Temporary tables and procedures

By Thomas Franz 2017/12/19 | Category: procedure
Rating: (not yet rated) |  Discuss |   Briefcase | 1,120 reads

CHECKSUM() and NULL

By Thomas Franz 2017/11/21 | Category: checksum
Rating: (not yet rated) |  Discuss |   Briefcase | 768 reads

Dynamic SQL and TempTables

By Thomas Franz 2017/08/25 | Category: dynamic sql
Rating: (not yet rated) |  Discuss |   Briefcase | 956 reads

Performance of OBJECT_NAME() & Co.

By Thomas Franz 2017/07/10 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 873 reads

Comparing with SQL_VARIANT

By Thomas Franz 2017/07/14 | Category: sql_variant
Rating: (not yet rated) |  Discuss |   Briefcase | 908 reads

SELECT with DISTINCT and TOP

By Thomas Franz 2017/06/19 | Category: select
Rating: (not yet rated) |  Discuss |   Briefcase | 1,210 reads

Index_ID of the PK in In-Memory-Tables

By Thomas Franz 2017/05/08 | Category: in-memory
Rating: (not yet rated) |  Discuss |   Briefcase | 881 reads

DECLARE multiple vars with default value

By Thomas Franz 2017/01/16 | Category: declare
Rating: (not yet rated) |  Discuss |   Briefcase | 1,318 reads

GetDate() in blocked sessions

By Thomas Franz 2017/01/04 | Category: getdate
Rating: (not yet rated) |  Discuss |   Briefcase | 1,303 reads

Comparing with NULL

By Thomas Franz 2016/09/26 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 1,419 reads

Partition elimination and variables

By Thomas Franz 2016/05/19 | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,157 reads
   Items 1 to 17 of 17