Smart Moves with SQL Server VMs – Data Movement
Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...
2014-04-10
982 reads
I’m a Traveling Man
We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...
2014-04-10
796 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
726 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,020 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
813 reads
Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
706 reads
this isn’t thunderdome
When I received my first MVP award for SQL Server it was fairly abstract to me until I went to...
2014-04-09
744 reads
Vote for me at SQLBits
SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...
2014-04-09
826 reads
Webcast Follow-Up: Introduction to Clustered Indexes and Heaps
Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps. I’d meant to...
2014-04-09
773 reads
Dedicated Administrator Connection
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-09
712 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
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