Four PASS Questions–My Take #PASSElections
As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer...
2017-09-19
422 reads
As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer...
2017-09-19
422 reads
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
706 reads
Hello friends, Please find my new post at this link – https://social.technet.microsoft.com/wiki/contents/articles/40141.delete-all-the-resources-from-a-resource-group-using-windows-powershell.aspx
2017-09-19
539 reads
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...
2017-09-19
343 reads
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
448 reads
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,623 reads
In this module you will learn how to use the Heatmap Custom Visual. The Heatmap is useful for show data...
2017-09-26 (first published: 2017-09-19)
2,151 reads
Photo by Chad Kirchoff on Unsplash
Prefer watching on YouTube?
In the ideal world, you fully test how your SQL Server will handle upgrading to...
2017-09-19
200 reads
Photo by Chad Kirchoff on Unsplash
Watch this week's video on YouTube
In the ideal world, you fully test how your SQL Server will handle upgrading to the latest version. You're able to catch...
2017-09-19
30 reads
In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...
2017-09-19
2,005 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