Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
962 reads
ArithAbort and SQL Agent Failures
ARITHABORT can be a short termed head scratcher. Pay close attention to what has changed in the environment. Test alternatives. And check those connection strings.
Related Posts:
Failed to Create the...
2019-01-07
20 reads
ArithAbort and SQL Agent Failures
ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...
2019-01-07
308 reads
SQL Bits Precon 2019
I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...
2019-01-07
271 reads
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....
2019-01-07
46 reads
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
322 reads
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,862 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect...
2019-01-07
35 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...
2019-01-07
237 reads
Profiler Is Dead, Long Live Extended Events
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
693 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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