Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.
2002-06-10
25 reads
Recompilation yields superior performance in some situations, although excessive recompilation can be detrimental. This article will discuss some of these costs and benefits, and will draw on contrasts between different versions of SQL Server to provide further context for understanding recompilation.
2002-06-07
1,291 reads
Here is a strait forward script that allows you to use CDONTS to send email. Note that the Subject, From, CC and BCC are all optional parameters. Because it uses a fully qualified path, this procedure can live in any database on the server. CDONTS will need to be installed on the server.
2002-06-06
726 reads
Our friends at Redgate asked us to pass this URL on to our readers. It's a very quick survey, help one our great supports by following the link!
2002-06-06
649 reads
SQLServerCentral.com has now launched it's third Resource Center. This one focuses on giving the reader everything they need to know about licensing SQL Server. All links in this area are user contributed.
2002-06-05
87 reads
LockwoodTech announces release of Auto-Audit 2.0, an entirely redesigned upgrade to it's popular SQL Auditing tool. Version 2.0 supports plug-in, customized audit architectures, scriptable trigger templates, a trigger and data management module, real data reports, and online analysis of audit data with grouping analysis.
2002-06-04
3,524 reads
SQLServerCentral.com this week launched its second Resource Centers. This time, focusing on DTS. The DTS Resource Center focuses on tracking bugs, articles and books from throughout the Internet.
2002-05-29
69 reads
The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java™ environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.
2002-05-29
3,342 reads
SQL Spy 4.0 is a program that lets you monitor your server real time to look for locking problems, unusual user activity or users that are using large amounts of your server resources. The program is like SQL Profiler in a tighter, easier package.
2002-05-22
151 reads
SQLServerCentral.com is proud to launch it's first Resource Center for security. It's a one-stop shop for anything related to SQL Server security. All content is user-contributed and contains links to content throughout the web.
2002-05-20
83 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers