Sending an e-mail has become very important in any system for purposes such as sending notifications. SQL Server database has an integrated mailing system. With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.
2006-11-15
3,424 reads
Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.
2006-11-13
3,890 reads
The same ANSI Standard SQL query can run against identical data on SQL Server and Oracle and return different results. So just because your application issues ANSI standard SQL, don't assume it's portable.
2006-11-09
2,041 reads
This video sample shows how the clustering algorithm can be used to automatically validate data.
2006-11-08
2,184 reads
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
2006-11-07
2,281 reads
Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.
2006-11-06
3,793 reads
You may find this shocking, but some IT people lie on their CV. Richard Morris offers a rare glimpse into the dark underworld of the people tasked with rooting out the CV fraudsters.
2006-11-03
3,591 reads
If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.
2006-10-31
2,682 reads
If your SQL Server app is suffering from poor performance and you suspect a missing index, then read on
2006-10-30
2,990 reads
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I am getting an error when I create the index but I...
Good morning all, I have been running into a very random weird issue that...
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers