Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.
2015-05-19
6,584 reads
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
2015-05-18
5,574 reads
One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.
2015-05-18
9,083 reads
SQL Saturday is coming to Vancouver, British Columbia on June 27 2015. Join us for a free day of SQL Server training and networking. Register while space is available.
2015-05-18
6,914 reads
Redgate's DLM Workshops are coming to Belfast, NI on June 26, 2015. Learn how to: deploy databases using Redgate's DLM tools, assess the different requirements of production and non-production deployments, and handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.
2015-05-15
7,393 reads
If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.
2015-05-15
9,082 reads
Join us for a free day of SQL Server training and networking in Davie, Florida on June 13, 2015. Admittance to this event is free, so register while space is available.
2015-05-14
6,155 reads
Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.
2015-05-14
11,622 reads
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.
2015-05-13
9,527 reads
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
7,275 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers