HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
581 reads
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
581 reads
Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to...
2013-12-24
703 reads
This year has been so awesome!! I hope to do better in the coming year and be able to share...
2013-12-24
452 reads
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,153 reads
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,459 reads
Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...
2013-11-26
624 reads
This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...
2013-11-17
554 reads
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
520 reads
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,459 reads
From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...
2013-11-11
1,059 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hi I got a message in VS saying I should update it so I...
Make your corporate events more engaging with a fun twist. Our booths capture energetic...
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