Tag Archives: SQL Server

Generating a Random DateTime in a Range in SQL Server

You can generate a random datetime (date and time) in SQL Server; you just need to use DATEADD a few times (once per component). The result is a truly random date and time. Continue reading

Posted in Tools | Tagged | Leave a comment

Simple Strategies to Boost SQL Server Performance

SQL Server can be a beast on your disk. Two easy ways to help raise performance for high-volume databases: Use a drive other than the Windows partition for the SQL Server DB files, and split the MDF and LDF files onto different drives if possible. Continue reading

Posted in Platform, Tools, Topic, Web | Tagged , | Leave a comment

Finding Circular Dependencies in SQL Server

SQL Server doesn’t allow a cycle of foreign keys, nor two or more paths to cascadingly delete rows from a table. Thankfully, there’s a script you can use to detect at least table reference cycles. Continue reading

Posted in Libraries, Web, Wndows Forms, WPF | Tagged , , | 3 Comments

Dropping an Active Database in SQL Server

How can you close open/active connections in SQL Server and drop the database? With a little statement like SET SINGLE USER. You can also abort transactions and force the database to drop immediately. Continue reading

Posted in Tools | Tagged | Leave a comment

Searching the Entire SQL Server Database

How can you search every row and column in a SQL Server database for a specific string? Well, we link you to a handy dandy SQL stored procedure that does just that! Invoke it, and be amazed! Continue reading

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment

Selecting Encrypted Columns in SQL Server

Decrypting columns in SQL Server requires a security key and security certificate. You need to convert the resulting value into the correct type; we explain the process, and summarize what you need and how to do what you need to do. Continue reading

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment