Dennis Cheung is a Senior DBA currently living in Hong Kong, he has been working with SQL server since 2000. He has supported a different version of SQL and loves to learn new technology.

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Linux to Windows Authentication

By

As you are all very well aware Linux to Windows for access to SQL...

Read the latest Blogs

Forums

object_name (st.objectid) returns NULL. How can I overcome/fix this?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

SSRS Export to separate pdfs

By spboutput

Hi everyone, can anyone tell me the process of how to create multiple pdf's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers