The Curse of Cursor Options
Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.
2018-11-30
3,017 reads
Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.
2018-11-30
3,017 reads
Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.
2018-11-29
687 reads
Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.
2018-11-29
2,515 reads
Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).
2018-11-28
2,382 reads
Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.
2018-11-27 (first published: 2018-10-30)
4,920 reads
Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.
2018-11-27
2,290 reads
Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues and Perform assessment when Migrating to Azure SQL Database or to SQL Server on an Azure Virtual machine.
2018-11-26
1,883 reads
In this tip we look at how you can monitor Azure health to know if there are any issues that may interupt your services running on Azure.
2018-11-26
1,932 reads
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,862 reads
In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.
2018-11-23
3,977 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers