SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details which includes Number...
2014-05-01
1,093 reads
One of the OP requested in the forum to find all table details of any database. The details which includes Number...
2014-05-01
1,093 reads
Quick thoughts about the work required to make all day meetings run smoothly:
Suitable space with enough seating (and reasonable chairs!)Turn...
2014-05-07 (first published: 2014-05-01)
1,385 reads
Summer SQL Server & Database Events In and Around NY-
Happy May everyone!
Hope those April showers will bring us May flowers! ...
2014-05-01
2,362 reads
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,438 reads
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...
2014-05-09 (first published: 2014-04-30)
14,357 reads
I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:
Continuous Integration for DatabasesMaintaining High Performance When...
2014-04-30
1,379 reads
Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...
2014-04-30
6,260 reads
I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...
2014-04-30
1,736 reads
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,532 reads
Hello Dear Reader! Just a quick update. I've been traveling a lot and I'm behind in posting some Decks & Demos....
2014-04-30
1,383 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Comments posted to this topic are about the item 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