Viewing 15 posts - 151 through 165 (of 1,221 total)
Eric M Russell (1/14/2016)
-----
[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]
January 14, 2016 at 9:36 am
The code he's using is filtering the object type, there's 26 different objects. BOL for SQL 2014 shows the types as:
AF = Aggregate function (CLR)
C = CHECK constraint
D =...
-----
[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]
January 13, 2016 at 11:04 am
I don't know if you might find this useful, but a long time ago I wrote some code for SQL Server 2000 for a similar purpose. It's probably overkill,...
-----
[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]
January 12, 2016 at 4:08 pm
Thanks for the info. Definitely good to know and worth bookmarking what you went through just in case....
-----
[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]
January 11, 2016 at 2:29 pm
Lynn Pettis (1/7/2016)
-----
[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]
January 11, 2016 at 9:44 am
My problem with maintenance plans is the lack of reporting. I'm old school: I started writing maintenance scripts with the first version of SQL Server and I've continued the...
-----
[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]
January 7, 2016 at 8:41 am
... When we have better solutions, or we can correct deficiencies, management doesn't want to spend the time or effort to do so. ...
Greed, pure and simple. The drive...
-----
[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]
January 7, 2016 at 8:30 am
TheSQLGuru (12/25/2015)
Jason A. Long (12/25/2015)
TheSQLGuru (12/25/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]
January 5, 2016 at 9:07 am
Thank you, J! Yep, PEBKAC strikes again.
-----
[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]
January 4, 2016 at 1:40 pm
Steve, I'd like to see your code because I can't duplicate it. I ran the following:
DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';
SELECT 'MD2' AS HashType, hashbytes('MD2',@HashThis) AS HashVal
UNION
SELECT 'MD4',...
-----
[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]
January 4, 2016 at 12:06 pm
There's some gaps that have developed in my knowledge of T-SQL that I need to fill in. I'd like to work on that and also on re-learning VB as...
-----
[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]
January 4, 2016 at 11:41 am
The last time I did a temp consulting gig in Phoenix, some 15 years ago, I was paid $120 an hour because when I left, the system continued to work...
-----
[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]
January 4, 2016 at 8:58 am
Steve, that's far too much free time on your hands!
Here's hoping you had a great holiday. 🙂
-----
[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]
January 3, 2016 at 5:23 pm
j.peavey (12/22/2015)
Please add to your bulletined list: All tables are six characters in length and use a cryptographic algorithm for the name.:-D
I'd recommend double-ROT13 as the crypto algorithm for the...
-----
[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]
January 3, 2016 at 4:17 pm
Yeah, if you're passing a query to an Oracle box, do you have any way of knowing if the delay is there? Totally different situation than a SQL Server...
-----
[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]
January 3, 2016 at 4:14 pm
Viewing 15 posts - 151 through 165 (of 1,221 total)