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.
Ever wonder who an MCDBA helps? Andy has posted the results of a recent survey of MCDBA's conducted by Dr. McKillip of Southern Illinois University. It's interesting reading. If you have time read and add your comments to the discussion!
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!
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.
Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!
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.
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.
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.
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.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?