Viewing 15 posts - 1 through 15 (of 34 total)
I often need to know the last time a proc ran and if it finished. So I created a simple table that logs start datetime, end datetime and any...
October 6, 2015 at 8:08 pm
An app and database I designed and built back in 1999 (go live date) is still going today. It was SQL 7, Now it is running on sql...
October 6, 2015 at 7:53 pm
Damn already done the clean up, but basically just the two lines as you wished.
August 18, 2015 at 6:50 pm
hmm normally addresses are attached to the borrower not the loan. but whatever.
Without some table structure knowledge (ie: do borrowers have ID's?)
Anyway something like this below will work, I copied...
August 18, 2015 at 5:13 pm
Constraints are a fact of life, the difference between a good project and a bad one is prioritising correctly and that can only come from doing the research and understanding...
July 22, 2015 at 4:38 pm
The steps I take to debug such a problem are simply isolate it and break it down.
Pull your query out , put a INTO #temp (and get rid of...
July 2, 2015 at 11:03 pm
Yeah I like the last approach, I'd probably have used datepart(dw,yourdatecolumn) =6 but that is dependant on the day offset, better using Datename, and it is easier to read.
But it...
July 2, 2015 at 10:41 pm
100 %
Dev and production. SQL thru to even a few plain win7 VM's for dev or remote admin purposes
May 8, 2015 at 12:30 am
wow really glad I asked why would you do that. Enjoying the answers. Thanks Guys.
March 11, 2015 at 2:04 pm
jonesboy21 (3/10/2015)
I ran a 4700+ store retail chain on 9400 instances of SQL express. Microsoft loved me 😎
Why would you do that? Surely the cost of maintenance and any development...
March 10, 2015 at 8:18 pm
Gary Varga (2/27/2015)
thottle (2/27/2015)
...One of the restrictions Steve did not mention is that Express, under license, cannot be used for an outward facing web site...
I believe that this was the...
March 1, 2015 at 1:52 pm
Conrad Muller (2/17/2015)
February 17, 2015 at 5:33 pm
SQL injection has been around for years. Thankfully someone made me aware of the ease in which it could be minimised years ago. For years I have been building...
February 17, 2015 at 1:20 pm
Agree with you entirely Steve.
I am self employed and all my work comes from gaining quickly an understanding of the Clients business and then coupling that with my IT...
January 26, 2015 at 1:55 pm
Viewing 15 posts - 1 through 15 (of 34 total)