Sound Off with Soundex
In this article, learn how to use phonetic algorithms such as soundex to make looking up names faster, easier, and more reliable.
2010-01-22
2,629 reads
Articles
The power of batching Transactions
This article analyzes the performance gains of batching multiple DML statements into a single transaction. New author Manor Lev-Tov examines the effect of grouping statements together instead of running them all as separate transactions.
2010-01-21
6,221 reads
How To Enable Caching in SQL Server Reporting Services (SSRS)
We have many SQL Server Reporting Services (SSRS) reports that use our OLTP systems as data sources. We are always adding new reports and the number of users running these reports is also increasing rapidly. We would like to look at enabling report caching as a way to reduce some of the load on our database servers. In this tip I will go over the steps needed to enable report caching for SQL Server Reporting Services reports.
2010-01-21
3,194 reads
Retrieving Identities on set-based inserts
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
2010-01-20
4,589 reads
Full Text Index Queries using CONTAINS and CONTAINSTABLE
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE.
2010-01-20
2,182 reads
Recovering data from corrupt tables using non-clustered indexes
At times database corruption happens and no good recovery path is available. It is possible to salvage data from indexes using query hints.
2010-01-19
6,011 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-19
2,220 reads
SQLSaturday #32 - Tampa, FL
If you are in the area, come to this great one day training event in Tampa, FL.
2010-01-19
1,159 reads
Caution with EXCEPT
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
2010-01-18
14,941 reads
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
2010-01-18
5,995 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers