“Invalid class [0x80041010]” error when trying to access SQLServer’s WMI classes
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have...
2017-09-07
1,422 reads
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have...
2017-09-07
1,422 reads
Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask...
2017-09-07
164 reads
Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask...
2017-09-07
381 reads
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,781 reads
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm...
2017-09-07
75 reads
I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective...
2017-09-06
393 reads
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
36 reads
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
1,609 reads
I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top...
2017-09-06
149 reads
I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top...
2017-09-14 (first published: 2017-09-06)
1,345 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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