Hi,

There is a small mistake in your code, as written the code will run forever as the loop variable is not incremented.  You need a Begin Statement after the While...

thanks, wasn't paying attention

Hi, I don't see the WMI Reader in my SSIS ToolBox, using SQL 2016, is there something I need to run or be a specific patch level or SQL 2017? ...

Hi,  to get the listing in 4.2, you need to add  " | Format-Table -Property name, membertype, definition"  thought it might help other newbies out, thanks for the article.  Rick

Hi, I think you have a typo, you create the type with one name and then use it with a slightly different name. Good Article, Rick

CREATE

Pray or listen to worship music or preaching, occasionally talk radio to here what they are saying about the two poor choices we have for presidential candidates.

It is, and it is working quite well, made some changes but the core would still be recognizable. Built a little DW to do some more in-depth trending but...

HI Can you tell me what source supports this statement? "1024MB and multiples thereof have previously caused problems in SQL Server"? I searched the web and didn't find...

Nice except the Fiscal Year to Date will not return correct results when the Fiscal Year is not in the same year as the current date. If the current date...

Does it save time when the file is expanded? It is a best practice to keep the file increase size relatively small because of the hit on performance when the...

Its ugly but this will convert int to time, no check if valid time is made except if more than 6 digits, note you could go into milliseconds etc by...

Hi Andy, Old topic of yours and all be it a small point; MS SQL has since at least SQL 4.2 and maybe farther back I understand that the...

Update: I was reviewing some of the other posts and see that the column must be nullable, made sense re-ran the test on a nullable column happen to be a...

I did not find the same results. The results for functions upper and substring did cause an index scan but the isnull function consistently returned results using index seek....