SQLServerCentral Article

InfoPath 2003 - Part 2

Continuing with Dinesh Asanka's series on SQL Server and Infopath 2003, he shows us this time how to build a report that joins two tables and includes some conditional formatting. Infopath 2003 is part of Office 2003 and is a great quick and dirty tool for getting to your SQL Server data.

SQLServerCentral Article

NULL Column Analysis

NULL values in columns can indicate a few things, the value isn't known, it's not yet been filled in, or perhaps, as Leo Peysakhovich argues, the column isn't being used? How many SQL Server tables do you have with extra tables and columns that are not being used? Or maybe never have been? This article looks at a statistical analysis of columns using NULLs to determine if you might be able to remove certain columns.

Blogs

T Sql Tuesday 170: Learning From Abandoned Projects

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Read the latest Blogs

Forums

Not able to connect on analysis services on azure

By astrid 69000

Hello, I am trying to migrate a tabular model from onprem to azure analysis...

File share witness in an Always On cluster

By robinpryor

Another DBA mistakenly created a file share witness for one of our ao clusters....

Improve Delete Performance in Table With Many Related Tables

By tgitchel

This simple delete statement drives CPU to 100% for long periods of time when...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers