Time to Vote-PASS Board of Directors
It’s that time of year where we get to vote for the three best candidates to serve a two year...
2012-09-28
1,515 reads
Blog Posts
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,751 reads
Yet Another Facebook Page - Living For SQL Server
I have created facebook page named "Living For SQL Serever" couple of days back.
https://www.facebook.com/LivingForSqlServer
Inviting our community friends to like this...
2012-09-28
1,802 reads
An Introduction to SQL Server
There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...
2012-09-27
811 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,929 reads
DBA Manager Needed in Orlando–Putting My Network to Work!
I”m working with a client in Orlando that needs a manager for their data team, seems like a prime opportunity...
2012-09-27
1,547 reads
Full Text Search – CONTAINS
I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....
2012-09-27
4,829 reads
MDS Error: “The status of the specified batch is not valid”
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...
2012-09-27
2,371 reads
Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we...
2012-09-27
933 reads
Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement
Nested Partitioned Views. Before we go...
2012-09-27
3,013 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...