Importing Data and New Hardware (Database Weekly)
Steve Jones looks at some of the interesting news this week in the SQL Server world.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Architectural Options for Asynchronous Workflow
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
Fundamentals of Storage Systems - The Basics of Spinning Disks
Your servers are only as fast as the slowest part, hard drives.
To feed other parts of the system we have...
Introduction to Cube Storage
BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Check Yourself
Can you trust the information you get online? There are lots of people that think so, and that's been one of the huge benefits of a highly connected world. Most of us ask questions and get help from others around the world using various forums. This Friday Steve Jones asks you about the help you get online.
A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network
Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.
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