Viewing 15 posts - 1 through 15 (of 15 total)
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...
June 24, 2019 at 6:08 pm
thanks, wasn't paying attention
March 5, 2019 at 12:27 pm
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? ...
March 5, 2019 at 11:17 am
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
February 7, 2018 at 8:48 am
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
November 6, 2017 at 7:44 am
March 31, 2017 at 1:45 pm
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.
October 10, 2016 at 10:20 am
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...
June 9, 2016 at 1:29 pm
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...
June 9, 2016 at 8:31 am
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...
November 18, 2015 at 10:02 am
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...
July 10, 2014 at 8:22 am
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...
December 5, 2012 at 9:25 am
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...
May 9, 2008 at 11:58 am
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...
February 28, 2008 at 4:17 pm
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....
February 28, 2008 at 4:07 pm