SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
875 reads
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
875 reads
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,665 reads
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
740 reads
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,388 reads
Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...
2013-08-07
995 reads
Earlier today I was required to pull the list of all SQL Login Accounts, Windows Login Accounts and Windows Group Login...
2013-08-06
1,412 reads
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,599 reads
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,618 reads
By default, SQL Server automatically assigns a value to the Identity Column for each new row inserted into the table....
2013-06-02
656 reads
In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...
2013-05-23
649 reads
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Kamil
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers