Viewing 15 posts - 226 through 240 (of 1,221 total)
Jeff Moden (7/6/2015)
... the MVP discussion emails (not available to the general public ...
I always suspected that you were part of a secret cabal, Jeff. :hehe:
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 6, 2015 at 11:19 am
bazmunro (10/3/2015)
...I converted a large thick Windows Dataflex app from flat file Btrieve to SQL, and chose MS's flavour...
Oh, man, I feel your pain! I spent nine years in...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 5, 2015 at 2:00 pm
In the mid '90s I wrote a blockwatch grant tracking system in Access, I left that org in 2001. Two years ago I went to have lunch with my...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 2, 2015 at 10:26 am
You might want to check out Plan Explorer, there's a free edition: https://www.sqlsentry.com/products/plan-explorer/sql-server-query-view.
Also, I'd recommend Grant Fritchey's book on execution plans, available for free as a PDF from Redgate: https://www.red-gate.com/community/books/sql-server-execution-plans-ed-2....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 1, 2015 at 1:05 pm
I attended Kevin Boles' Tune Like A Guru session at the El Paso SQL Saturday recently and he said the most important thing to do when you have a serious...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 1, 2015 at 10:54 am
Have you experimented with the MERGE statement? I've never used it, but it seems to me that (A) the WHEN MATCHED could be used to set a value to...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
October 1, 2015 at 10:42 am
I use a trigger that I modified from Pop Rivett's column (https://www.simple-talk.com/content/article.aspx?article=301#forum from 2006. Put the trigger on any table to be audited and you get one record per...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 29, 2015 at 4:33 pm
Yay! Attending the DLM workshop before the Denver SQL Saturday produced actionable knowledge! (even if I have no idea when I'll be able to implement VCS in my shop)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 29, 2015 at 3:59 pm
ChrisM@Work (9/24/2015)
Why are you using NVARCHAR for an email address?
We now have Unicode URLs, so why not Unicode characters for email addresses. You can Google Unicode Email and there's...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 29, 2015 at 8:54 am
Sean Lange (9/17/2015)
... I would rather peel M&Ms in the desert than work with this system.
Sounds like the ERP system used by a previous employer. I told my friends...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 25, 2015 at 10:41 am
Lynn Pettis (9/16/2015)
Just as long as people use the semicolon (;) as a statement terminator not a begininator. That is my pet peeve.
I saw one argument to using it...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 16, 2015 at 10:05 am
"And they didn't believe us when we said that we were serious about only three password attempts."
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 16, 2015 at 8:13 am
erichansen1836 (9/15/2015)
... In this day and age, rarely do systems last longer than a couple years anyway.
I had an interesting experience about a year ago. I worked for an...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 15, 2015 at 12:00 pm
Rod at work (9/15/2015)
Wayne West (9/14/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 15, 2015 at 9:16 am
I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone came out with a source control package...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
September 14, 2015 at 1:26 pm
Viewing 15 posts - 226 through 240 (of 1,221 total)