Writing my presentation part 1: The brainstorm/dump
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
387 reads
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
387 reads
So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance...
2019-03-06
254 reads
I just discovered this the other day and I had to share it.
First, we need a query in Management...
2019-03-05
589 reads
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,823 reads
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
935 reads
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
1,464 reads
Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...
2019-02-27 (first published: 2019-02-11)
2,393 reads
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
799 reads
SQL Server 2008 is reaching end of support this year, so upgrading your SQL Server might be on your mind....
2019-02-25
440 reads
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
349 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers