"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 on the...

I admit I'm really sick of the ridiculous lists of...

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...

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...

• This reply was modified 3 years, 5 months ago by  Ed Wagner.

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...

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...

• This reply was modified 3 years, 6 months ago by  Ed Wagner.

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...

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...

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...

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...

I got the same one. Well done and...

Okay, I don't have control over the DNS process. I filled out a form and sent it along. I'm told it's set up the same as working instances. Also,...

Is IpAll set in your SQL configuration manager?

I'm no domain admin, but has the name in AD propagated to everywhere it needs to? I ask because I've had times when...

• This reply was modified 3 years, 10 months ago by  Ed Wagner.
• This reply was modified 3 years, 10 months ago by  Ed Wagner.

Hi Jeffrey, many thanks!

I have the column in my table telling me the last time rows were added.

I guess I could use that one, but if I do, isnt...

So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering...

• This reply was modified 3 years, 10 months ago by  Ed Wagner.