There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.
2009-12-11
4,754 reads
Don Schlichting demonstrates the development of a SQL Azure ASP Dot Net application, leveraging our existing TSQL and Dot Net skills.
2009-12-11
6,129 reads
In this tip we will look at an add-in that helps you better identify changes between two versions of an SSIS package.
2009-12-10
3,071 reads
Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.
2009-12-09
5,402 reads
One of the Junior SQL Server Database Administrator in my company approached me yesterday with a dilemma. He was assigned a task to rename few of the databases in Beta and Production environments; the reason being the database name was based on some other project that is no longer relevant to the data which is presently stored within the database. At first I started to tell him, but figured it would be smarter to document the same and share the information.
2009-12-08
6,195 reads
The cornucopia of products for handling distributed data in the cloud includes everything from lightweight key-value stores to industrial-strength databases
2009-12-07
2,186 reads
I know there are fixed server roles that come with SQL Server. How do I best use them within my installations? What should I watch out for?
2009-12-04
5,135 reads
This articles explores how you can work with filtered models, a powerful new feature introduced in SQL Server 2008 that allows you build models on slices of a mining structure.
2009-12-03
2,607 reads
I need to encrypt my data within SQL Server and I plan on using the built-in encryption functionality in SQL Server 2005 and 2008. However, I'm looking at symmetric and asymmetric key algorithms and while I see information saying to use symmetric keys, I don't understand why. What's the difference between the two and why is a symmetric key algorithm preferred over the asymmetric key ones?
2009-12-02
3,414 reads
Are your database servers not performing well? Have you discovered two or more virtual servers running on the same node? Shailesh Khanal shows you how to generate a status report for multiple database servers and services, schedule it to run automatically and send it out via email.
2009-12-01
2,555 reads
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers