Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
676 reads
Jen McCown
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
483 reads
T-8d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelveeight days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-17
582 reads
Know a young IT go-getter? Get her nominated!
Yesterday, I told our Groupies: I feel give-y today. Is there anything you’d like me to promote for you? Wendy...
2010-09-15
469 reads
New Hotness: sys.sql_modules
I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or...
2010-09-15
510 reads
Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!
Content rating: Beginner
This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for...
2010-09-14
669 reads
T-12d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelve days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-13
706 reads
Tip: Use System Views to Compare Column Datatypes
Let’s say that you have a staging table, that then loads to a destination table in the same database. If...
2010-09-13
531 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,677 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,552 reads
Blogs
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Playing with the Data API Builder
By Steve Jones
I published an article today on the Data API Builder, which is a way...
A New Word: Dolonia
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Forums
Understanding allowed topics for testing
Hi, I am a first time writer looking to author some content here. I...
Do As I Say, Not As I Do
Comments posted to this topic are about the item Do As I Say, Not...
Filter a SQL Server Audit with a predicate
Hi Gents, Silly question, but it's been a long time since I've done this....
Question of the Day
The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers