Wildcards and Indexes
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,751 reads
Blog Posts
Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations
A little more than a year ago while working at Idera, I was consulted on reports from a few clients...
2013-05-21
1,230 reads
Consulting company: Perm/Salaried vs 1099/W2
One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company...
2013-05-21
2,008 reads
CREATE SCHEMA can do what?!?!?
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,146 reads
Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller
Development and demo environments can be hard to come by. Over the course of this series you will learn how...
2013-05-21
2,297 reads
Digby’s Top 10 reasons you need a DBA
Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.
They can handle unexpected database growth...
2013-05-21
464 reads
Get synonym definitions for all databases in server
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
831 reads
Microsoft Lync Through the Web
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...
2013-05-21
794 reads
SQL Saturday Atlanta was incredible
This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA....
2013-05-21
511 reads
Sql server 2012 links
Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/
2013-05-21
1,088 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
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