2017-11-23
976 reads
T-SQL
2017-11-10
1,185 reads
2017-11-07
1,034 reads
2017-10-23
1,115 reads
Simple SQL: Random Thoughts
How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers.
2017-10-19
3,623 reads
2017-10-06
1,103 reads
The Basics of Good T-SQL Coding Style – Part 4: Performance
There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.
2017-10-05
6,056 reads
2017-09-29
1,038 reads
2017-09-26
1,187 reads
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,638 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
SQL in an Azure VM Backup
Comments posted to this topic are about the item SQL in an Azure VM...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers