Viewing 15 posts - 1 through 15 (of 22,219 total)
Ooh, I worked at a place like that.... for six months.
I lasted 18 months at this place, mostly because there were some very promising opportunities once it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 6:46 pm
Amen to that !
Cheers!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 1:26 pm
About 15 years ago, I was hired as the first DBA at a small medical records company. My first project was to assess the overall environment and make suggestions/changes...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 1:25 pm
Grant I know what you mean. And this article's message is a good one! But I wonder how far one can take this?
For example, I am writing this on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 1:24 pm
I've got a situation at present where a BI product has an API and a UI that uses the API.
The API has "features", as in looks like a bug,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 1:20 pm
Just never forget, downstream, in the future, you, or someone, is going to want to report on this data, slice and dice it. The more you make that easy now,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 26, 2026 at 12:59 pm
No arguments from me, you know that.
I will make one small point. A thing that can't go on, won't. We may be seeing the end of the ecosystem we came...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 16, 2026 at 12:41 pm
I totally get it. We just interviewed a guy for a Principal Database Engineer who couldn't answer correctly the first question to explain the different type of JOINs. I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 5, 2026 at 2:59 pm
Yeah, I gave up looking for actual questions on the forums.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 1, 2026 at 2:57 pm
I hear you. It is, in some ways, but not a lot, easier, but only in the short term. In the longer term, sooner or later, someone is going to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2026 at 8:59 pm
You can literally do anything you want, any way you want to store information.
However, I always recommend that people think about reporting and searching. Is it possible, sure, you may...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2026 at 12:01 pm
I'm confused. You said you had two columns, one rowversion and one you're going to update in some way, but you want to store it as it was rowversion? In...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2026 at 12:30 pm
Figured this board out along with Stack, Leftist not neutral. It's on.
Sorry, but what?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2026 at 2:54 pm
So you're storing it twice, once as the automated column value and another time as something updated, trigger or what not? I'd go with the varbinary then.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2026 at 2:56 pm
If you're using rowversion, use the rowversion data type. Can you use others? Sure. Why? What functionality will you get that you don't already have? What functionality will you lose?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2026 at 12:31 pm
Viewing 15 posts - 1 through 15 (of 22,219 total)