Finding Cluster Log Errors
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever...
2019-02-04 (first published: 2019-01-18)
2,889 reads
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever...
2019-02-04 (first published: 2019-01-18)
2,889 reads
When I first joined the programming team at my previous job in an aerospace company, the first observation I made...
2019-02-01 (first published: 2019-01-18)
2,127 reads
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,952 reads
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
303 reads
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,089 reads
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...
2019-01-18
1,360 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-01-17
96 reads
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders. The...
2019-01-17
26 reads
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
778 reads
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...
2019-01-17
226 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