As we all know, there are various numeric data types, such as TINYINT, INT, SMALLINT, BIGINT, NUMERIC, DECIMAL, SMALLMONEY, MONEY and FLOAT. I was working on a SSIS package,...
2021-03-10 (first published: 2021-03-07)
413 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-10
8 reads
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another...
2021-03-10
20 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-03-10 (first published: 2021-03-04)
776 reads
First, please, please, please, avoid NoLock. You can lose data, or get strange results, as Jason Strate demonstrates (blog | video). Before you read further or try this, read...
2021-03-10
172 reads
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint, he had htis neat trick: git config --global init.defaultBranch main Apparently, this is a new...
2021-03-09 (first published: 2021-03-01)
364 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-09
12 reads
One of the frequently quoted ETL best practices is to disable your non-clustered indexes during a data load. Basically the conventional wisdom is that you disable the non-clustered indexes,...
2021-03-09 (first published: 2021-03-02)
1,136 reads
It has been a while since I wrote a blog post for TSQL Tuesday and there is no better time then now following on from Brent Ozar’s Invite about...
2021-03-09
156 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Brent Ozar (blog | twitter) asks us to talk about data...
2021-03-09
2 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Comments posted to this topic are about the item Do You Really Need HA?
Comments posted to this topic are about the item The New Database CheckDB
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers