The NEWSEQUENTIALID system function is an addition to SQL Server 2005. It seeks to bring together, what used to be, conflicting requirements in SQL Server 2000; namely identity-level insert performance and globally unique values.
If you are thinking of taking a SQL Server 2005 MCP exam, now is the time to do it. And with exam insurance, you can get two chances to pass and a free year of Technet!
SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.
What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.
In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make
working with XML data easier than ever.
Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.
his white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server
2000 database. In this part, he expands upon the processing to access that data from multiple nodes.
This article introduces some techniques that will allow you to pinpoint exactly where the performance issues are in your system, so you'll know exactly where to spend your time (and money) in solving them.
Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers