On the Third Day…
Mais Oui! But of course, we must have some french hens for today! Today we have the third day of pre-Christmas. And as was mentioned we have more undercarriage...
2012-12-15
8 reads
Blog Posts
On the Third Day…
Mais Oui!
But of course, we must have some french hens for today! Today we have the third day of pre-Christmas....
2012-12-15
879 reads
Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools to capture, curate, manage, and process the data within...
2012-12-14
39 reads
Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...
2012-12-14
455 reads
Cross-database Queries by Contained Users
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,684 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain your msdb undercarriage. Today I want to continue...
2012-12-14
12 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain...
2012-12-14
1,192 reads
Reblog: December 7 to December 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-14
640 reads
SQL Server Data Tools (SSDT) – December 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: December version: 10.3.21208.0, November version 10.3.21101.1, September version: 10.3.20905.0, initial version:...
2012-12-14
1,584 reads
SQLOS Basics - Chennai User Group Meet - Presentation File Download
Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.
You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip
Tomorrow, I...
2012-12-14
2,238 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