T-SQL Tuesday #105 Invitation: Brick Wall
It’s time for another T-SQL Tuesday. The brainchild of Adam Machanic (b|l|t), and designed to strengthen the SQL Server blogging...
2018-08-07
346 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Does a Primary Key always have stats_id 1?
Back to the SQL Server Basics with Wayne
The Myth
I recently was attending a presentation where the presenter stated that the...
2018-07-09 (first published: 2018-06-28)
2,430 reads
SSMS reset window layout (Day 37)
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
4,552 reads
New blogger: Jamie Wick
New SQL blogger
Jamie at the 45th Parallel (South) – New Zealand
This post is just a quick shout-out. My friend and co-leader...
2018-06-15
336 reads
Splitting Strings in SQL Server 2016
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,372 reads
Removing the time element from a datetime
Killing Time – or removing the time element from a datetime
Over the course of time, we all collect scripts and routines...
2018-06-07
2,045 reads
Removing servers from the SSMS connection dialog (Day 36)
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
1,681 reads
SSMS: Batch Separator (Day 35)
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
2,044 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,065 reads
Primary Replica Jobs
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
961 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers