Do you know your getdate()?
This article takes a closer look at SQL Server getdate() and sysdatetime() functions.
2012-02-03 (first published: 2010-05-12)
27,463 reads
Jacek Osuchowski
Using Server Side Traces for Dynamic Performance Evaluation
This article describes a method of gathering and analyzing performance data using SQL Trace.
2009-12-01
5,385 reads
2009-03-11 (first published: 2009-02-13)
1,623 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Script to help check performance and bottle necks
Hello SSC and Happy Friday! I am looking for an "all in one" script...
Txn log file is full. Error 9002
Hi All, Here is the scenario on of the test servers. The transaction log...
How to define data types
What are the things you consider when you create a new table and define...
Ask SSC