Thanks everyone for a fantastic SQL Saturday Lincoln #165
Today I presented two sessions at SQL Saturday Lincoln (almost in my backyard!) – Virtualizing Business-Critical SQL Servers and Database Health...
2012-10-07
447 reads
Blog Posts
Class and instance variables in Python 2.7
The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...
2012-10-06
2,356 reads
How to avoid windows REBOOT after any operation required restart ?
Issue :
Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different...
2012-10-06
1,245 reads
10-minute SQL: Filtered Delete: join vs. sub-select vs. exist
I was doing some simple tuning of procedures for a client when I came across some delete statements that I...
2012-10-05
876 reads
2012 PASS Elections Letter Of Recommendation From Karen Lopez
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-05
1,065 reads
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked...
2012-10-05
1,999 reads
Finding and removing hidden characters in your data using dynamic T-SQL
It has been a long morning for me. It was supposed to be a standard run for our quarterly data...
2012-10-05
676 reads
How to Make SQL Server Listen on Multiple Ports
Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...
2012-10-05
1,187 reads
Is Instance name SQLEXPRESS is fixed for Express edition only ?
A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide...
2012-10-05
674 reads
Kathi Kellenberger speaking at Midlands PASS
On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...
2012-10-05
1,090 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...