SQL Server 2008: new data types and .Net 2 with and without SP1
If you use the new data types in SQL Server 2008, and your front-end application uses .NET 2, you may hit difficulties. András explains why and how...
2008-07-10
3,445 reads
SQL Server 2008
Enhancement in variable declaration – SQL Server 2008
Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it.
2008-07-09
3,010 reads
White Paper: SQL Server 2008 Compared to Oracle Database 11g
Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
2008-06-19
4,197 reads
Security Overview for Database Administrators
SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.
2008-06-12
3,272 reads
Dependency Tracking in SQL Server 2008
People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.
2008-05-22
1,515 reads
Row Value Constructor in SQL Server 2008
This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.
2008-05-16
3,194 reads
UPSERT Functionality in SQL Server 2008
This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.
2008-04-24
6,046 reads
The HierarchyID Datatype in SQL Server 2008
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
2008-03-25
21,143 reads
SQL Server 2008 security and compliance features reduce security risks
Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.
2008-03-24
2,187 reads
2008-03-14
2,870 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
T-SQL Tuesday #202: The Two Outages I Won't Ever Forget
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
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...
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