Inside the Statistics Histogram & Density Vector
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-04 (first published: 2014-01-28)
4,194 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,262 reads
Powershell in a Month Day 13 – Remote Control
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-27
1,058 reads
Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance
We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....
2014-01-27
1,886 reads
Basic RegEx in SSMS
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
6,204 reads
February 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s a cold, cold day here in Minnesota. A great day for staying in and working on some in-home...
2014-01-27
544 reads
Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs
As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...
2014-02-03 (first published: 2014-01-27)
2,509 reads
SQL Prompt – new features in version 6.x
I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late...
2014-01-31 (first published: 2014-01-27)
3,084 reads
Last Weeks Top “Reading” Links #68
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-27
976 reads
What does “challenging” really mean?
I had lunch with an old friend last week. We hadn’t spoken in a while and we were catching up...
2014-01-27
853 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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