Viewing 15 posts - 5,356 through 5,370 (of 59,068 total)
Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of your choice?
Nope... not a...
April 16, 2021 at 6:32 pm
If you own a Kindle (I don't yet) and read technical books on the subjects of SQL Server and T-SQL, I sure would like to hear from you because I'm...
April 16, 2021 at 3:57 pm
Anyways, I'm open to suggestions. There may be SQL features of which I'm unaware.
My question would be... Does the reviewer need to know which columns actually changed? Do they...
April 16, 2021 at 3:38 pm
(3) SQL does that itself, so that's only a very minor consideration.
I might be misinterpreting what you're saying above but, at face value, I have to ask...
How so? ...
April 16, 2021 at 2:08 pm
Yes, am engaging right now into doing the test you mentioned.
thank you.
I was just attaching the Excel file to answer Jeff's questions.
The testing is a great idea but...
April 15, 2021 at 9:26 pm
My view is that the vast majority of the time row comp is beneficial, likely 90+%. So I think they're better off always doing it vs never doing...
April 15, 2021 at 4:36 pm
You're definitely preaching to the choir. What I'm worried about is the wording you used.
Row compression should automatically be used for most tables.
"Should automatically be used" is all that most...
April 15, 2021 at 4:01 pm
No, it won't use 9 bytes under row compression unless it truly needs all 9 bytes. Row compression should automatically be used for most tables.
While row compression can certainly...
April 15, 2021 at 2:16 pm
I have to agree with Frederico. I've had both methods be better than the other. "It Depends".
Yep.
There are trends. More often than not, I see having...
April 15, 2021 at 1:50 pm
Heh... I normally avoid helping people with anything having to do with gambling. You seem to indicate that you're making money at it. What's my cut going to be if...
April 15, 2021 at 1:36 pm
People REALLY need to read the "A Word of Caution" section at the end of the linked article. I'll also add that if the retry is due to bad code...
April 15, 2021 at 1:29 pm
Steve Jones - SSC Editor wrote:How to Get Current Date in SQL Server: https://www.mssqltips.com/sqlservertip/6817/sql-current-date/
Reminded me of some discussions here.
The answer to Jeff's interview question!
I thought the same thing when I read...
April 15, 2021 at 12:52 pm
I have to agree with Frederico. I've had both methods be better than the other. "It Depends".
April 14, 2021 at 10:59 pm
Lookup the key word CONVERT. You'll need to use the format number of 101.
April 14, 2021 at 6:47 pm
Heh... no problem. We've all had similar problems. Even after more than 2 decades of this stuff, I still have my "WTF? Oh, DUH!" moments especially since, like you, I...
April 14, 2021 at 6:28 pm
Viewing 15 posts - 5,356 through 5,370 (of 59,068 total)