SQLRally Nordic 2015
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
616 reads
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
616 reads
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had...
2015-01-28
599 reads
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
633 reads
This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...
2015-01-12 (first published: 2015-01-08)
7,362 reads
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
792 reads
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,545 reads
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
6,843 reads
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,031 reads
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,567 reads
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
8,853 reads
I posted on Terraform and Azure SQL last year but wanted to see what...
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
A couple of days ago I was doing some cleaning on some Azure SQL...
Comments posted to this topic are about the item The On-Call Load
Comments posted to this topic are about the item Two Table Hints
Comments posted to this topic are about the item Database Dashboards in Azure Data...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers