Viewing 15 posts - 16 through 30 (of 62 total)
USE AdventureWorks2012Big
GO
CREATE TABLE Sales.SalesOrderHeaderBig(
SalesOrderID int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
RevisionNumber tinyint NOT NULL,
OrderDate datetime NOT NULL,
DueDate datetime...
Mike Byrd
Wow, didn't know the article was going to generate a fire-storm on TSQL syntax. The original purpose was to see if there was a difference getting max/min value of a...
Mike Byrd
Actually all the suggestions made are good ones, and as most have pointed out all is very environment sensitive. 90% of the DelFlag column are marked 'N' and the others...
Mike Byrd
Index work had already been accomplished -- hence the index + key lookup. The query returns every column in the table, and I am just opposed to creating a non-clustered...
Mike Byrd
Same query plan, same cost, same IO, same cpu time. No change defining it as a variable first.
Mike Byrd
From the estimated query plan. Statistics were up to date, so estimated rows were close to actual rows.
Mike Byrd
I noticed that also when using a columnstore index as a clustered index and a non-clustered Hash Primary Key (for in-memory tables). When using dm_db_xtp_hash_index_stats I get one row...
Mike Byrd
Hmmm, you finally put in writing (and script) what I have been doing for years. Yeah! Great work!
Mike Byrd
Interesting topic. After retiring from the Air Force I started in management and eventually ended up as a CTO for an insurance company here in Texas. After a...
Mike Byrd
I was an early user of SQL LiteSpeed. Yes you are correct, the less IOs offerred by compression resulted in tremendously less backup and restore times. Although depending...
Mike Byrd
Makes it even more interesting if you add following:
insert into @test-2 values ( NULL )
Answer is still 6.
Mike Byrd
Data presentation -- still an art, definitely not a science. The Challenger accident is a significant occurrence where we had the data, but was never presented in a way...
Mike Byrd
Well written for what it covered, but my initial expectation before reading the article was that you would touch more on techniques for handling transaction log growth and also handling...
Mike Byrd
Just to make sure we are all on same page, the way I've heard the Microsoft CAT engineers explain for row and page compression that the data is compressed both...
Mike Byrd
Viewing 15 posts - 16 through 30 (of 62 total)