T-SQL Enhancement: THROW
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...
2011-06-14
1,087 reads
T-SQL Enhancement: Sequence
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
526 reads
T-SQL Enhancements in SQL Server Denali (2011)
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
451 reads
Speaking at 24 Hours in the Cloud
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,576 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need help on query within 2 column, generate another column
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
SELECT blocking DML and DDL
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
query filling up tempdb
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC