Remove files from a filegroup
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,676 reads
SQL 2016 - The Time Has Come!
Microsoft dropped it on us this morning:
Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg
I read the article and was...
2016-05-02
941 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading...
2016-05-01
12 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,099 reads
SQL Server 2005 Modernization Checklist
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
564 reads
Power BI Box and Whisker visualization vs. Box Plot chart in SSRS
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,374 reads
3 Things I Wish I Knew When I Started Using Entity Framework
Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...
2016-04-30
25 reads
Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,143 reads
Possible PARAMETER SNIFFING Scenario in SQL
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...
2016-05-11 (first published: 2016-04-29)
3,720 reads
A New Look & A New Direction
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you...
2016-04-28
818 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 Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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