Viewing 15 posts - 106 through 120 (of 5,583 total)
RBarryYoung (5/27/2016)
Anyone else going to SQL Saturday in Philly next week? I don't think I recognized anyone on the speakers list...
I'll be there.
May 30, 2016 at 7:47 am
Grant Fritchey (5/24/2016)
WayneS (5/24/2016)
Grant Fritchey (5/24/2016)
Thrilling stuff Steve. Congrats!My two are graduating high school tomorrow (and turning 18 on the same day, **** I'm old).
Especially if you consider that...
May 25, 2016 at 6:16 pm
Grant Fritchey (5/24/2016)
Thrilling stuff Steve. Congrats!My two are graduating high school tomorrow (and turning 18 on the same day, **** I'm old).
Especially if you consider that you waited to...
May 24, 2016 at 3:56 pm
ThomasRushton (5/23/2016)
Been a bit quiet here over the weekend - was there an outage, or did everyone else suddenly have an attack of Real Life?
SQL Saturday Atlanta for me.
May 23, 2016 at 9:05 am
In your article, you have:
var results = db.Customer.Where(c => c.State == "Ohio");
Which is changed to this to limit the query to only the necessary columns:
var results = db.Customer
...
May 17, 2016 at 1:12 pm
You gotta just love the way ORM does this:
var results = db.Customer.Where(c => c.State == "Ohio");
what really was running behind the scenes was this:
SELECT
*
FROM
Customer
WHERE
State...
May 17, 2016 at 12:54 pm
jasona.work (5/12/2016)
Michael L John (5/12/2016)
Ed Wagner (5/12/2016)
Lynn Pettis (5/12/2016)
J Livingston SQL (5/12/2016)
Lynn Pettis (5/12/2016)
And Post Padder is still at it.yeah....about 15 today
We can call him pp. :w00t:
Agreed. Now...
May 12, 2016 at 3:41 pm
Sean Lange (5/9/2016)
OP:
My SQL update string looks like this: "UPDATE " + tableName + " SET ??? = " +...
May 9, 2016 at 4:08 pm
solomon.jernas (5/9/2016)
Error:Login Failed for user 'APP' Reason Password did not matche that for the login provided
Error No : 18456 : Serverity 14 State 8
State 8 means that...
May 9, 2016 at 1:10 pm
David Burrows (5/6/2016)
Grumpy DBA (5/4/2016)
May 6, 2016 at 8:42 am
Anyone else having trouble receiving the SSC newsletters? I just received Saturday's "Database Weekly", and I haven't received any of the daily ones this week.
May 4, 2016 at 9:30 am
xsevensinzx (5/3/2016)
Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages...
May 4, 2016 at 9:27 am
To all: the latest version of this script is up on my blog.
May 2, 2016 at 5:37 pm
Anyone have experience loading ASCII flat files into tables where the files may contain some extended ASCII characters? Any special tricks involved to accomplish this load?
Thanks,
May 2, 2016 at 7:09 am
Personally, I think this would be the most useful for the OP:
/* Version number binary from daily registy */
DECLARE @VERSION_STRING VARBINARY(MAX) = 0x666377247978767F6E2A6C803C3D7B8376808281817B42687E8D4A658F8A8D88419B8F8D8D8D474863A19C9190A2925F94A5A7A698656E9E59A69CA1695EABAEB5B7A8ACB5BDBABABBBC79ADB67DC2B1BA888674CACFCEC4C9C0CAC37DC7C3D4D5D991DACAC7D3DADDACD0CFE19FA4E9E092;
/* Inline Tally for parsing the binary string...
April 20, 2016 at 8:32 am
Viewing 15 posts - 106 through 120 (of 5,583 total)