Viewing 15 posts - 841 through 855 (of 39,717 total)
I suspect SQL Server 2016 runs better than 2005.
It's always an "it depends" discussion. Some things run for years, and there's no reason to change. Some things do need to...
February 1, 2024 at 10:13 pm
Ah, I realized I had an extension added. I'll update the article with this.

Likely you added the sp_whoisactive extension
January 31, 2024 at 3:01 pm
Good Stuff. There were a couple of the queries that didn't run against my Synapse instance. "can't convert to int". I had to cast some of the columns to...
January 30, 2024 at 10:20 pm
Hi Steve, very useful posts around ADS, however, when I fire my ADS for a 2k16 SQL, in the monitoring part I have no "Server Reports" nor tempdb as...
January 30, 2024 at 10:18 pm
These things made a big difference in my career before SQL Server Central. Answering questions elsewhere, doing a talk at a UG, they helped me stand out as well. You...
January 30, 2024 at 10:14 pm
Publish well written standards, Enforce them. Period.
Yep, and don't spend a lot of time building them. Propose something, vote on it, and enforce it. If you find the need...
January 30, 2024 at 10:11 pm
Honestly I find few people building ER diagrams, much less doing extensive modeling. Some customers still use ErWin, which is really the standard. I loved ER/Studio a long time ago,...
January 26, 2024 at 10:28 pm
All good advice that I learned and try to remember today. I might give this list to younger people.
January 26, 2024 at 5:52 pm
When IT departments start tightening their belt - the guy whose primary job is to pick arguments over tabs and naming conventions, the guy whose brightest idea is to...
January 26, 2024 at 5:36 pm
Tabs vs. Spaces and Singular vs. Plural, ...commas before or after?
Really? You're debating and voting on this? Holding meetings and discussions? Wasting everyone's time with this crap?
I think the...
January 26, 2024 at 5:35 pm
Interesting. I think AI works better, in general, with more generic things, or with some code prompting, which is easier in C# than SQL.
I'm doing some testing with SQL Prompt...
January 22, 2024 at 4:15 pm
Heh... let's look at the first paragraph in the article...
...
Heh... wanna learn something new and exciting??? Then actually learn what you can do in SQL.
And watch out for people...
January 20, 2024 at 5:42 pm
Kris Kovacs has kept his original NOSQL comparison article up-to-date. I refer back to it at intervals.
Thanks, need to read this.
January 20, 2024 at 5:41 pm
We use Cassandra extensively in one of our software products. Its "active-active" clustering, and being able to perform a write on any node, is the primary reason why we...
January 20, 2024 at 5:40 pm
Viewing 15 posts - 841 through 855 (of 39,717 total)