| |
 = Members-Only  = Registered Guests
[Oracle] [SQL Server] [XML] [Home]
These articles are always free for members, but are currently available to registered guests as well. This list of articles
changes daily.
Discuss | See Current Member Articles
Register for FREE Access to These Articles.
When you register, you can choose to be a registered guest and have access to these articles,
or you can become a dues-paying member, with a great-many benefits, and get full access to everything on SSWUG and
many other benefits.
| SQL Server 2008 Management Tools - (Buck Woody) Microsoft has made several changes in the tools area for each release of SQL Server for the past few years. One of the largest jumps was from SQL Server 2000 to 2005. They changed th... [more]
|
| Server Audit Specifications in SQL Server 2008 - (Ashish Kumar Mehta) SQL Server 2008 introduces a new feature called SQL Server Audit. Auditing an instance of SQL Server involves tracking and logging events that occur on the system. This featu... [more]
|
| Security in SQL Server 2005 Part II - (Vinod Kumar) In Part I on Security with SQL Server we did try to get into some aspects of security which as an administrator or developer one needs to know. We started with instance security, d... [more]
|
| SQL Server 2008 New Features - Row Constructors - (Nidal Arabi) Microsoft SQL Server 2008 with its release included some new features that some of us (as developers) will find interesting and useful. In this article, which will be followed by ot... [more]
|
| Backup compression in SQL Server 2008 - (Tim Chapman) New to SQL Server 2008 is the native ability to compress database backups. This great new feature results in a smaller (sometimes much smaller) backup file, which saves disk space, ... [more]
|
| SQL Server Hidden Stored Procedures - (Michael Ceranski) sp_msforeachdb and sp_msforeachtable are very powerful stored procedures. They allow you to loop through the databases and tables in your instance and run commands against them... [more]
|
| SQL Server Clustering Active vs Passive - (Tim Ford) Recently, I found myself rebuilding our production SQL Server 2005 cluster. Trust me when I say that a DBA does not take on a task like this because they want to. No, we encountered ... [more]
|
| Resource Governor in SQL Server 2008 - (Ashish Kumar Mehta) SQL Server 2008 introduces a new feature called Resource Governor which enables Database Administrators to manage SQL Server workload and critical system resource consumption... [more]
|
| SQL Server 2008: The Debugger is back - If you have worked in SQL Server 2000 and were used to using the T-SQL debugger, you might have lamented its absence in SSMS in SQL Server 2005. In SQL Server 2005, one can debug the stored proce... [more]
|
| Performance of inserts and IGNORE_DUP_KEY - (Alexander Kuznetsov) If your data has a small percentage of duplicates, then IGNORE_DUP_KEY may speed up your inserts. For larger amounts of duplicates, IGNORE_DUP_KEY may slow them down signifi... [more]
|
| Partition Wizard Makes it Simple - (Allen White) The partitioned table was one of the great new features of SQL Server 2005. We could now manage data based on some range data, usually a date value, and keep the different ranges in... [more]
|
| How do I Reseed a SQL Server identity column? - (Susan Harkins) Microsoft SQL Servers identity column generates sequential values for new records using a seed value. The term seed refers to the internal value SQL Server uses to generate the ne... [more]
|
| Restoring Master - beyond the technical - (James Luetkehoelter) Thank Greg Low for reviewing my book and pointing out one of the copy-edit issues in it (I wasn't involved in that process by choice and schedule, a mistake I regret). As Gr... [more]
|
| Avoid Untrusted Constraints in SQL Server - (Armando Prato) Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after ... [more]
|
| SQL Server 2008: Table Valued Parameters - (Kathi Kellenberger) In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multip... [more]
|
| Triggers...Evil? - (Louis Davidson) Say it isn't so. "It isn't so." Glenn Berry thinks so in his post here. When I read his post I thought I was going to really get into it with Conor's post here, called the Troub... [more]
|
| Loading XML data into SQL Server 2008 - (Ashish Kumar Mehta) SQL Server DBAs will often come across a scenario where they need to load data from an XML document into SQL Server 2005 or 2008. As XML is being used widely by many organiza... [more]
|
| More on SQLDiag - We had briefly touched upon the usage of SQLDiag in some of our previous posts including the one here. While working on a client issue this weekend, it was surprising to see that none of the clie... [more]
|
| Creating SQL Server Tables Part 1 - The fifth part of the SQL Server Programming Fundamentals tutorial looks at the creation of tables within a SQL Server database. Tables provide structured storage locations for all of the inform... [more]
|
| Interview With SSIS Guru Jamie Thomson - (Denis Gobo) I asked for some names of people who you would like to see interviewed here at Sqlblog and Jamie Thomson's name popped up a couple of times. I contacted Jamie and he was kind enough ... [more]
|
| The SQL Server Sample Databases - pubs - (Buck Woody) Were in a series that explains the main sample databases that you can use with SQL Server, and in this tutorial Ill show you how to find, install and work with the first (and smalles... [more]
|
| Database Normalization Basics - (Mike Chapple) If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you "Is that database normalized?" or "Is that in BCNF?"... [more]
|
| SQL Server Profiler Part 2 - (Don Schlichting) Profiler is tool that monitors the events and activity running on a SQL Server. Using profiler, this monitoring can be viewed, saved, and replayed. The results can be saved to a... [more]
|
| sys.dm_exec_requests - (Aaron Bertrand) One of the dynamic management views (DMVs) that is very useful in troubleshooting query performance is sys.dm_exec_requests. The documentation around this DMV, however, is quite... [more]
|
| SQL Server and .Net Data Type mapping - (Francois Malgreve) Today I would like to post a table listing the corresponding .Net Type to use with each SQL Data Type. This comes in handy when writing ADO.NET code.
|
| System Data Collection Reports - (Greg Larsen) In my last article (http://sql-server-performance.com/articles/per/Management_Data_Warehouse_p1.aspx) I introduced one of the new SQL Server 2008 features known as the Management Da... [more]
|
| Avoid Using Cursors - (Molly Pell) Transact-SQL cursors are used mainly in stored procedures, triggers, and Transact-SQL scripts in which they make the contents of a result set available to other Transact-SQL statemen... [more]
|
| SQL Server 2008: Spatial Data, Part 8 - (Jason Follas) In this, the eighth part in a series on the new Spatial Data types in SQL Server 2008, I'll step away from the database and do a little spatial coding using .NET.
|
| A first look at SQL Server 2008 (part 1 of 3) - (Ken Casada) During the last days I found the time to have a first look at SQL Server 2008. In this 3 parts blog (Ill post the second one the coming week) I will summarize some of the most intere... [more]
|
| Data Mining with SQL Server 2005 - (The JZ) In my research, we do a lot of data mining and machine learning. While we do not employ SQL Server 2005 to perform the operations, the underlying concepts are the same. Data mining can r... [more]
|
| Introduction to SQL 2005 Profiler Part 1 - (Don Schlichting) Profiler is a tool that monitors the events and activity running on a SQL Server. Using profiler, this monitoring can be viewed, saved, and replayed. The results can be saved to... [more]
|
| Automate Audit Requests - (TJay Belt) Periodically, an internal auditor would stop by my desk and ask me to show them all the users and permissions on a particular database. This is easily gathered, and most of us know h... [more]
|
| Execute SQL statements in Integration Services - (Tim Chapman) Executing SQL statements is one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services (SSIS). This tutorial walks you through the process of adding... [more]
|
| Reuse Your Code with CROSS APPLY - (Alexander Kuznetsov) Suppose you are using SQL Server 2005, and you want to truncate your DATETIME value, leaving only date part of it, as follows:
DATEADD(day, DATEDIFF(day, '19010101', Last... [more]
|
| Using xp_ReadErrorLog in SQL Server 2005 - (Dan McClain) I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I... [more]
|
| Convert numbers to fractions using SQL Server - (Tim Chapman) I recently worked on an interesting problem that involved converting a decimal number to a fraction value in SQL Server. At first glance, it seemed reasonably simple, but after digg... [more]
|
| Dynamic SQL, Dynamic Ordering and Paging - In some of our previous posts, we have covered both Paging of recordsets as well as conditional ordering using the CASE statement in the Order By clause. In today’s post, we will address one of t... [more]
|
| SQL Server 2008: Sparse Columns - (Paul S. Randal) It's been quite a while since I wrote a blog post on a flight but I happened to be playing with a CTP-6 VPC on the way down to Orlando and thought I'd do the first in a few posts... [more]
|
| UPSERT Functionality in SQL Server 2008 - (Muthusamy Anantha Kumar) The UPSERT command inserts rows that don’t exist and updates the rows that do exist. The Word UPSERT is a fusion of the words UPDATE and INSERT. UPSERT was officially in... [more]
|
| Translate Microsoft SQL (MSSQL) To MySQL - (Ben Nadel) This is going to be a post that I update from time to time and I just wanted to kick if off right now. For years, I have been working on Microsoft SQL Server and I have reached what I... [more]
|
| Interesting observation with table > 1TB - (Kevin Cox) We have a project using SQL 2005 with a table that is several terabytes. This table has a varbinary(max) column with an average length of 150k bytes.
|
| SQL Server Database Requirements - In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the databa... [more]
|
| CHECKSUM and Tempdb - (Sunil Agarwal) You may recall that starting with SQL Server 2005, you have an option available to enable CHECKSUM on the user databases. For details, please refer to http://blogs.msdn.com/sqlse... [more]
|
| SQL Server Index Checklist - Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an exis... [more]
|
|
|
|
|
|
