Join the Community - AKA, "Where did he go, George?"
In recent days I've kind of dropped off the map with respect to SQL Server, including with the Security and...
2010-05-11
765 reads
Blog Posts
May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
468 reads
Minutes of the April 2010 PASS Board Meeting Published
This was a phone meeting on April 8th, 2010, that covered:
Possibility of an online track at the 2010 PASS SummitDiscussion...
2010-05-11
693 reads
Minutes of the February 2010 Board Meeting Posted
Strangely we’ve had the March minutes up for many weeks, but just now getting the February minutes posted. This was...
2010-05-11
601 reads
Notes from the May 6th, 2010 oPASS Meeting
We moved to Thursday this month to line things up so that Dean Richards from Confio could do a presentation...
2010-05-11
550 reads
Put your left LOB in, put your left LOB out…
It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more...
2010-05-11
1,915 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
776 reads
Simple Production Script Auditing Best Practices: Including Query in the Result Set
To make it easier for others to audit the results of a script you have run on current production servers,...
2010-05-11
1,498 reads
Some New DMV Queries for SQL Server 2008 R2
I was spelunking around in SQL Server 2008 R2 today, after looking at a PowerPoint presentation by Madhan Arumugam about...
2010-05-11
1,791 reads
SQL Server with MS Access .adp Project file
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,866 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...