T-SQL Tuesday 89 - The times they are a changing!
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-11
380 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-11
380 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-03-27
304 reads
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-09 (first published: 2017-03-01)
2,969 reads
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-08
434 reads
2017-03-03
Just wanted to put a quick post out there for the people who follow me. I very recently made a...
2017-03-03
339 reads
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-08 (first published: 2017-02-03)
9,126 reads
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-03
396 reads
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
401 reads
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
272 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers