2015-10-05
16 reads
2015-10-05
22 reads
Detect Worst Performing SQL Queries During Peak Hour
on 10th oct 01.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday,...
2015-10-05
785 reads
Implementation of Data Compression – SQL Server
Data Compression
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of...
2015-10-05
1,146 reads
Trace Flags in Azure SQL Database
One of the ways that you take more direct control over your SQL Server instances is through the use of...
2015-10-13 (first published: 2015-10-05)
1,268 reads
SQL Source Control and Git–Getting Started
It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS...
2015-10-05
547 reads
SQL Source Control and Git–Getting Started
It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS...
2015-10-15 (first published: 2015-10-05)
7,614 reads
Backup Deployed Sessions
Having just completed several segments on the metadata for deployed sessions, it is time to bring all of that information together and see how it can be used -...
2015-10-05
21 reads
Backup Deployed Sessions
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...
2015-10-12 (first published: 2015-10-05)
547 reads
The powerpoint for my SQL Server Security Basics session
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...
2015-10-05
549 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 Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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