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
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
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
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
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
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
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
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
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
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Is there a trigger to notify when a new SQL Agent job is created/modified?
Hello I have a view based upon a number of tables I'm selecting...
In an Azure SQL Managed Instance there is no option to create what we...
In which editions can I use Full-Text and semantic search?
See possible answers