Undocumented use of the Columns_Updated() function
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
614 reads
Blog Posts
Midlands PASS Chapter - August 2, 2007
"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software
The Midlands PASS Chapter...
2007-07-31
1,556 reads
User Groups Moved to New Domain
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,549 reads
ApexSQL's Industry Experts program
If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it...
2007-07-25
1,722 reads
SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,497 reads
What is BI?
I actually started writing an article on this, but it's been sidetracked with travel and other stuff. However I do...
2007-07-21
1,472 reads
A Graphical View of the Physical Allocation of a Database
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,648 reads
More Navigation
I've looked at the daily newsletter for a year now and I've wondered about the table of contents. It seems...
2007-07-19
1,395 reads
Tampa Code Camp - Again
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,364 reads
New version of SQL Server 2005 Best Practices Analyzer available
If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for...
2007-07-17
1,712 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers