WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
12 reads
SQL Server: utilize partitioning to purge large tables
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...
2015-07-17
3,610 reads
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
757 reads
Introduction To Query Store In SQL Server 2016 – Part 2
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,117 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,097 reads
SSC Editorial: Is the Golden Age of Information Technology Almost Over?
Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential...
2015-07-16
551 reads
Next oPASS Meeting is July 23, 2015 with David Crook
The next OPASS meeting is July 23, 2015, featuring David Crook from Microsoft doing a presentation on predicting home value...
2015-07-16
553 reads
SSMS 2015
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...
2015-07-16
999 reads
Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...
2015-07-16
1,120 reads
New Features of SQL Server 2016
The next version of SQL Server looks to add more and more features helpful in database design and administration as...
2015-07-16
990 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...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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