How to change TempDB system Database files location?
Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB
You can use below...
2014-07-07
15,058 reads
Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB
You can use below...
2014-07-07
15,058 reads
DISCLAIMER
I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With...
2014-07-07
1,060 reads
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
683 reads
My very first IT job was a bit daunting for me. I really wanted to do my best but I...
2014-07-07
560 reads
Continuation from the previous 32 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
We all love and use Columnstore Segments, but we all kind of...
2014-07-04
148 reads
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-07-04
895 reads
If you are in the USA, I hope you take some time today to enjoy your family and friends and...
2014-07-04
672 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-04
379 reads
I am absolutely delighted to share the great news that I have been selected as one of the speakers for...
2014-07-04
640 reads
IN CONGRESS, July 4, 1776.
The unanimous Declaration of the thirteen united States of America,
When in the Course of human events,...
2014-07-04
662 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