Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-08
2,355 reads
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-07
2,075 reads
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-04-06
3,375 reads
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-04-05
1,493 reads
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-30
4,648 reads
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-29
2,259 reads
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers