Fill Factor, Why Do You Taunt Me? Part 1
Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...
2013-11-15
743 reads
Blog Posts
Friday Followup For November 15, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
479 reads
Reblog: November 8 to November 14
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-15
757 reads
SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,156 reads
SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,503 reads
The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,670 reads
Use application lock to synchronize T-SQL code
Application lock can be used to synchronize T-SQL code, you can control if the session is able to run the...
2013-11-15
5,042 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 3
In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.
DISCLAIMER: I...
2013-11-14
3,527 reads
Baseline Maintenance Statistics Job For Indexes. (say that three times fast)
This is a project I've been working on for a while. The information is all there... how it's queried may...
2013-11-14
504 reads
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
920 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers