Viewing 15 posts - 2,791 through 2,805 (of 59,067 total)
So dig into that one query and find out what's going on with it and what's causing it to wait.
September 5, 2022 at 8:26 pm
I wonder if instead of using literal number 8000, you could limit the number of rows in the first CTE
to count the number of delimiters in the string, but...
September 5, 2022 at 8:21 pm
Heh... checking out the following link...
https://financesonline.com/10-biggest-hotelst-in-the-world-the-highest-number-of-rooms-to-stay-in/
... The entries that list the number of rooms, floors, and buildings seem to indicate that TinyInt will probably work just fine. You would need...
September 5, 2022 at 8:14 pm
I'd likely do similar but with TinyInt for each. There'd also be a usage category column.
Having been to Las Vegas in the last few years, not sure a...
September 5, 2022 at 7:59 pm
It's just my opinion but that violates the rules of integer division
Why would you expect the rules of integer division to apply when the input data are not...
September 5, 2022 at 7:57 pm
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me...
September 5, 2022 at 7:52 pm
Good timing - the current feature list for SQL Server 2022 includes the function GENERATE_SERIES(), which looks like a handy way to generate the Numbers or Tally rows.
Agreed. It...
September 5, 2022 at 7:42 pm
Unless you have a system, such as Ola Hallengren's index maintenance solution, there's nothing in SQL Server that logs this information. And, no... even though index REBUILDs update stats, I...
September 5, 2022 at 4:22 pm
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for the specs,...
September 5, 2022 at 2:25 am
[
Correct... but it didn't convert to FLOAT in other versions either (thank goodness for that!)... It converts numeric literals (constants) that have a value larger than the bounds...
September 5, 2022 at 1:55 am
You simply can't constrain a column to NOT NULL if it contains NULLs. There has to be a value in every row of a NOT NULL column or one that...
September 4, 2022 at 11:38 pm
SomeID doesn't have to have a value to have the FK placed on it. FK's are "if something, other than a NULL, is present, it has to be in that...
September 4, 2022 at 10:42 pm
Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/
What parts of the SQL standard has Microsoft not yet implemented?
At the prices they charge for the specs, I'll never...
September 4, 2022 at 10:36 pm
No need for the Dynamic SQL, the WHILE loop, or any of the other complexities that go along with those things.
Here's a sample "tbl_names" table that I made up for...
September 4, 2022 at 10:15 pm
I have to say, in this case I would use a char/varchar column for room numbers, not an int. Even if the hotel guest rooms are all numeric,...
September 4, 2022 at 9:14 pm
Viewing 15 posts - 2,791 through 2,805 (of 59,067 total)