Myths and Misconceptions about Transaction Isolation Levels
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-27 (first published: 2014-01-21)
4,303 reads
Get Rid of These 5 T-SQL Bad Habits with SQL Prompt
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
618 reads
Understanding CXPACKET wait stats in SQL Server
Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...
2014-01-21
1,264 reads
Best advice I ever got on negotiating consulting rates and salary negotiations
Back when I was getting ready to take the plunge and begin consulting I sought advice from a friend who...
2014-01-20
802 reads
Schema-only Backups and Restores
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,552 reads
Powershell in a Month Day 11 – Filtering
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-20
1,143 reads
Monitor availability groups and availability replicas status information using T-SQL
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,834 reads
Power BI Contest Entry Voting
You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest...
2014-01-20
705 reads
Counting the Existing, and Missing, Rows
I saw this as a problem recently from someone and thought it would make a good post. As I was...
2014-01-20
740 reads
Assumptions and clusters – the double whammy
I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...
2014-01-20
853 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers