Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
2001-05-15
14,789 reads
Articles
DTS Basics
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
2001-05-15
11,235 reads
Incorrect Reporting of Date and Time in Performance Log Files
If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.
2001-05-15
3,040 reads
Non_Continuous Replication
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
2001-05-15
4,712 reads
Tech Tales
There is a web site devoted to humorous tales from the tech
support field. Check out these samples and submit your own.
2001-05-15
1,216 reads
2001-05-15
1,902 reads
2001-05-14
1,454 reads
New SQL Server 2000 Data Types
In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.
2001-05-14
6,754 reads
Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,784 reads
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,500 reads
Blogs
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Forums
Alert For Blocking in Azure SQL Managed Instance
In an Azure SQL Managed Instance there is no option to create what we...
Power BI on Prem License Question
Hi We have an on prem power BI running on a physical SQL2022 enterprise...
Querystore information missing, why?
Anyone experienced an interval in Querystore missing information? In the environment I'm in right...
Question of the Day
Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers