Lifehacking – Not such a good idea?
I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author...
2012-05-23
1,027 reads
Analyzing TPC-E Benchmark Performance by Physical Processor Core
The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is...
2012-05-23
2,171 reads
Columnstore indexes and memory
Columnstore indexes are built and processed completely in memory. You will receive an out-of-memory error if you do not have enough memory...
2012-05-23
1,467 reads
Watson Plays Jeopardy
I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...
2012-05-23
848 reads
Denali – Day 23: Data Quality Services (DQS)
Denali – Day 23: Data Quality Services(DQS)
Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...
2012-05-23
1,478 reads
Plan cache in SQL Server 2008R2
I was curious to look at the effect of database options, on the SQL server plan cache.
I have restored the...
2012-05-23
1,194 reads
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?
One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...
2012-05-23
91 reads
Marketing Ideas for Chapters & SQLSaturday
I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...
2012-05-23
731 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-22
37 reads
The Tally Table and Expanding Rows
Suppose you had some data like this:
Class Limit
————— ———–
Calculus 5
History 4
Physics 2
But what you really want is this:
Class ...
2012-05-22
1,475 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