Jeff,

I just love that quote. "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"  

It...

Sir, I just need it for presentation purposes only. Please suggest any tool...

BWAAA-HAAAAA!!!  All the answers are incorrect... the correct answer is "This is easy to do in T-SQL... why don't you stick with that"? 😀

Never mind...

Jeff Williams is using the result of your query... that makes the CROSSTAB (which does the pivot) a bit more complicated and, perhaps, a bit slower (maybe not... it's...

Tech,

Is there a fixed maximum number of people that can work on a work order?

Are you looking for something like the following?

USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_ShowWorst]
/**********************************************************************************************************************
Purpose:  
This store procedure returns the "worst" performing queries in descending order...

So, I broke this down a bit, using a tally table to project to the future. I think all your dates after n= 5 will be the same, but...

I've never used Brent's BlitzIndex but... you say that everything is the "same" on your boxes... is the data identical, as well?  Probably not.

And I love Sergiy's "P.S.".  Great example. ...

While I agree that people need to learn new things (I'm in the process of learning a fair bit about AWS myself... and, unfortunately, am learning that it's not all...

Compression to save disk space is of dubious value unless it saves IO.

With technologies such as Fusion-IO and SSDs where you are talking about literally thousands of times that...

I'm thinking not... at least not non-SQL related...

We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild...

Dude!  What's with all the SPAM in your signature line???

It seems to me that if a company wants to really be effective (especially a software company), innovation shouldn't be limited to just 1 day or 1 week during working...

Hi,

My command is  :  EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1

And I have one file in the directory, but the out is  : (0 rows affected)

I am running this on SQL Server 2017...