We mostly use SSMS.

We tried to move to SSDT to assist with source control and deployment, but found this only worked well with small schemas. Our largest database is well...

I'm glad you folks liked it. That problem occurred in a production system I developed and had me scratching my head for a while. Why did my query return no...

CREATE TABLE SalesArchive

(

Salesid INT PRIMARY KEY NONCLUSTERED

, SalesPersonID INT

, SaleDate DATETIME2

, SaleTotal NUMERIC(12, 4)

);

GO

CREATE CLUSTERED INDEX SalesArchive_CI_SalesPersonID ON dbo.SalesArchive(SalesPersonID) ;

GO

Yep: qustion definitely needs adjusting:

INSERT...

@t.ovod-everett : good one.

I tested on SQL Server 2012 and the following works great

DECLARE @NullIfFmtOnly int = (SELECT 1);

but using a constant does not work i.e.

SET FMTONLY ON

SET @NullIfFmtOnly=1

gets the...

A great article - A lot of these will be added to my list of interview questions.

I was got by a few of them and it prompted me to...

Hi Lynn,

Nice article and an interesting discussion.

I am wondering if any folks who have been following this discussion can explain or corroborate this phenomenon:

Last year I was working on a...

Im inspired. Sydney has an active group but I havent gone in person for years. Time to get off my butt.

I like the article - it gives a clear rundown on the pros and cons of the simple built in diagramer, which I have found very handy.

The fact that the...

Thanks for your comments folks.

I had forgotten about the SET ROWCOUNT and #tempTable methods . Those worked for all the older versions of SQL and still work now. I just...

It is worth pointing out that :setvar variables are not like variables in a programming language. They are more like constants. I think it works this way: SQLCMD evaluates the...

Great article, David.

I had not seen examples of the error and standard outputs before.

Kuldip: it looks as though your windows login does not have windows integrated access to the server....

The registry fix worked for me.

I installed SQL 7.0 MSDE on top of a working SQL Server 2005 adn the 2005 was clobbered. I tried re-installing SQL 2005 as a...

Hi Brian,

I am looking forward to the recordings very much. The timing is a bit difficult for me to attend live.

I have a question already:

Where does Performance Point fit into...