SQL Server 2016–Live Query Statistics
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...
2016-11-15 (first published: 2016-11-10)
2,068 reads
Blog Posts
SSIS Catalog Project Versioning
If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all...
2016-11-15 (first published: 2016-11-11)
1,848 reads
We are Back Again..
After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...
2016-11-15
527 reads
Business Analytics Day Jan 11, 2017 Chicago
I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...
2016-11-14
439 reads
Is it safe to grant Administer Bulk Operations?
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...
2016-11-14 (first published: 2016-11-10)
2,363 reads
Monday Coffee 2016-11-14
Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase...
2016-11-14
346 reads
Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,726 reads
2016-11-14
494 reads
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,246 reads
Creating Custom Databases with SQL Prompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-11-11 (first published: 2016-11-01)
1,685 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