SQLServerCentral Editorial

Community at PASS Summit

Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]

External Article

Profiler and Server Side Traces

Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Error message in launching web service url in sql report server

By Teewhy

I am getting the following error when I launch web service url in sql...

How to Pivot daily date to a week Row

By Chris Spencer

I have data as below which is a per day view, I wish to...

SSRS Report Upgrade issue with # Temp tables for 800+ lines of Query

By ralahari

one of the Report which calls two Data sets , Data set1 Contains ,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers