Viewing 15 posts - 1 through 15 (of 9,387 total)
Just like to say congratulations to Jeff for reaching 1 million points:
Thank you, kind Sir and thank you and all the denizens of this fine...
March 17, 2022 at 7:12 pm
Just a quick venting/raging......Entity frameworks using code first is the spawn of the devil himself. It is seriously one of the worst anti-patterns I have ever seen....
March 17, 2022 at 7:10 pm
Does anyone else immediately think of the Monty Python skit every time they see or hear the word “spam”???
Wonderful spam, marvelous spam.
For those who haven't seen it...
March 16, 2022 at 1:11 am
"I review it". How long does THAT take?
And why does it need reviewed for "safety" if they don't have the permissions to change anything...
December 14, 2021 at 8:44 pm
YES!
"Nice to have: 2k years experience with DBCC TIMEWARP()."
And then sit back and see how many people actually respond. @=)
I admit I'm really sick of the ridiculous lists of...
July 1, 2021 at 8:55 pm
Got this through the email today: (unedited) Azure, Web API, C#, MVC, Entity Framework, jQuery, CSS, Bootstrap, React, JavaScript, Azure DevOps, PowerShell, Automation, SQL, Transact-SQL, Webservices, Agile, Messaging, Azure...
July 1, 2021 at 6:00 pm
That might also be the reason why they've done the RBAR thing in the trigger. They don't want to have everything during and Insert or Update roll back if...
June 14, 2021 at 7:28 pm
I just took a glance at the trigger. The size of the thing is truly horrendous.
Not sure if it was truly built for single row processing because it'll probably...
June 14, 2021 at 2:52 pm
I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject. Here's the link to the...
May 12, 2021 at 2:51 pm
I guess what you’re asking for is the amount of space actually used by data pages within the space allocated to db files of your databases.
To give you...
April 1, 2021 at 4:03 pm
samalex, there's definitely room for user groups. The SQL community is, IMHO, the best in the world. I've worked in other database platforms during my career and they had lots...
February 18, 2021 at 3:17 pm
Everyone's already addressed the SSN and I'm glad it was hypothetical. Kristin hit the nail on the head regarding the PK. The only thing I'd say to watch out for...
February 12, 2021 at 11:54 pm
You'll first want to import the file into a table as an XML column. Then you can query the data from the XML in the table. Here's an example using...
February 12, 2021 at 11:26 pm
Grant/Steve/anyone else, just received the email about PASS legacy moving to RedGate, well done for any/all of you who made that happen!
I got the same one. Well done and...
January 28, 2021 at 8:36 pm
Viewing 15 posts - 1 through 15 (of 9,387 total)