Speaking at the SQL PASS 2014 Summit
I’m happy to announce that I will be speaking at the SQL PASS Summit this fall. The summit will be...
2014-06-25
842 reads
I’m happy to announce that I will be speaking at the SQL PASS Summit this fall. The summit will be...
2014-06-25
842 reads
I’m actually having problems identifying the utility of execution plans when working with natively compiled procedures. Or, put another way,...
2014-06-30 (first published: 2014-06-25)
1,916 reads
Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit....
2014-06-25
740 reads
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,662 reads
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
14 reads
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
15 reads
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex...
2014-06-25
475 reads
An auto-growth event is the process by which the SQL Server engine expands the size of a database file when...
2014-06-25
1,113 reads
There may be an easier way, but this was a quick way to find ALL the checked out files in...
2014-06-24
1,487 reads
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
787 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...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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