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,587 reads
Articles
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,009 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,889 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
Improving Data Compression Fidelity Without Sacrificing Speed
Making it easier to handle huge data sets
2010-01-18
2,682 reads
Local Temporary Tables and Table Variables
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
2010-01-15 (first published: 2008-09-01)
29,109 reads
2010-01-15 (first published: 2009-12-28)
92 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Lindeteves Tlpn/wa:085373737551
Gedung Hayam Wuruk Indah, Jl. Hayam Wuruk No.100 Lt 1 Blok A-L 01,CKS 056,...
BCA KCP Cyber 2 Telpon/WA:08137887595
BCA KCP Cyber ??2 Telpon/WA:08137887595.Gedung Cyber ??2 Lantai Dasar, Jl. HR Rasuna Said 5...
BCA KCP Cyber 2 Telpon/WA:08137887595
BCA KCP Cyber 2 Telpon/WA:08137887595.Gedung Cyber 2 Ground Floor, Jl. H. R. Rasuna Said...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers