SQL Server 2014 CTP1 Released
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
607 reads
Blog Posts
SQL Server: Part1 : All About SQL Server Statistics :Density Vector
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
11,063 reads
Terminate a SSIS package after specific time interval.
Terminate a SSIS package after specific time interval.
There are several ways you can execute scheduled SSIS package/job they are:
A) SQL...
2013-06-25
9,007 reads
The Secret to Keeping Your Cool Like an Experienced Production DBA
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
In this post I share with you what I...
2013-06-25
24 reads
VMware vSphere Storage Performance - Thick vs Thin Provisioning
Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...
2013-06-25
4,502 reads
Baseline SQL Server with SQL Sentry Performance Advisor
Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...
2013-06-24
2,932 reads
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
769 reads
Don’t Use MD5
“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably...
2013-06-24
934 reads
Dynamic calculations of running totals
Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...
2013-06-24
1,323 reads
I Don’t Care
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
745 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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