Shrink a log file…AUTOMATICALLY?
Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First...
2016-02-25 (first published: 2016-02-22)
2,636 reads
Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First...
2016-02-25 (first published: 2016-02-22)
2,636 reads
This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...
2016-02-22
1,137 reads
In the Previous blogs we have seen about virtual memory related concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.html
We came across concepts like Address Window Extension, Physical...
2016-02-24 (first published: 2016-02-22)
4,102 reads
A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out...
2016-02-26 (first published: 2016-02-22)
1,919 reads
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,858 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
35 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
30 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of...
2016-02-26 (first published: 2016-02-22)
1,561 reads
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...
2016-02-22
1,166 reads
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes something changes without our knowledge and is running differently...
2016-02-22
33 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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