PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
688 reads
Blame it on Connect
Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...
2015-02-02
557 reads
T-SQL – Query to get Distinct,Sorted, Comma Separated values in to a variable
CREATE TABLE #temp(name char(3))
INSERT INTO #temp VALUES ('CD')
,('AB')
,('LM')
,('BC')
,('GH')
,('KJ')
,('AB')
DECLARE @cols AS NVARCHAR(MAX);
SELECT @COLS = substring(list, 1, len(list) - 1)
FROM (SELECT list =
(SELECT DISTINCT...
2015-02-10 (first published: 2015-02-02)
10,413 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
15 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,576 reads
Mentor blog
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
289 reads
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....
2015-02-09 (first published: 2015-02-01)
7,674 reads
Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
16 reads
Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,155 reads
Outlier Detection with SQL Server, part 3.4: Dixon’s Q-Test
By Steve Bolton
…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we...
2015-01-30
2,549 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers