SQL Server Random Sorted Result Set
In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.
2015-03-10
8,200 reads
In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.
2015-03-10
8,200 reads
Conrad Wolfram is the 'younger Wolfram' of Wolfram Research, the company behind Wolfram|Alpha and Mathematica. He wants to transform the way in which we engage with mathematics. In particular, he would like to reform mathematics education to make greater use of information technology, and he is also leading the way with interactive publishing technology.
2015-03-09
7,173 reads
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
2015-03-06 (first published: 2013-11-05)
25,173 reads
After finding it difficult to find seriously useful information on Azure blob storage written after Storage Client Library 1.7 (and we’re on 4.something now), Robin Shahan decided to try and fill that gap with this article.
2015-03-06
6,064 reads
There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.
2015-03-05
7,574 reads
Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.
2015-03-04
9,623 reads
How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.
2015-03-03
6,470 reads
One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.
2015-03-03
6,821 reads
Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.
2015-03-03
6,471 reads
We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.
2015-03-02
3,764 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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