Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 59,101 total)

Reply To: Are the posted questions getting worse?

Sergiy wrote:
So, it uses the same kind of lookup table but stored in Windows Registry.
Not sure how gods is it in terms of performance, but it does not eliminate the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 2:13 pm

#3791325
Reply To: Size of table

... post deleted. Accidental duplicate.

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 2:07 pm

#3791324
Reply To: Size of table

.. post deleted. Didn't see the OP's latest post.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 2:06 pm

#3791323
Reply To: Size of table

It's a shame that the OP didn't explain how they determined the table size.
carsten.saastamoinen wrote:
You can get the information from this select-statement. It shows the size of the table and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 1:45 pm

#3791310
Reply To: Ignore the entire record if a matching record is found

Steve Collins wrote:
Jeff Moden wrote:
Heh... as a bit of a sidebar, it's nice to see someone use the term "Record" correctly. 😀
Has a consensus been reached and record = row? I fear...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 3:35 am

#3791218
Reply To: how to calculate the RAM used while running a query

Calculating the amount of RAM used by a query isn't a very common question and so my curiosity has been piqued quite a bit. Why did you need to know...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 28, 2020 at 3:17 am

#3791215
Reply To: Index Fragmentation

p.s. To be sure, my intention is to make all of that "auto-magic" for Row-Store indexes. I'm about 80% complete on that... as you know, the last 10-20% of something...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 4:09 pm

#3791167
Reply To: update country information based on the address + city for 5000 contacts.

Interesting.
First, the original post on this thread was from 2.5 years ago. I wonder if the OP ever resolved their problem.
The really interesting thing is that, although this is an...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 2:57 pm

#3791159
Reply To: Ignore the entire record if a matching record is found

Heh... as a bit of a sidebar, it's nice to see someone use the term "Record" correctly. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 3:38 am

#3791141
Reply To: Inserts not propagated in transactional replication

This is a bit of a hunch but you might want to increasing the "LanMan" timeout in Windows. We had a similar problem with remote backups that would work just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 3:33 am

#3791140
Reply To: SQLServer Agent not sending dbmail on job completion

Dunno for sure but my first guess is... is the user for the SQL Agent Service setup as an email user on your email system?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 3:16 am

#3791136
Reply To: Using SSIS packages build in VS2010 when migrating SQL server from 2008 to 2016

As a bit of a sidebar, this is why I jump through flaming hoops to ensure that we never use SSIS. I've not had a problem avoiding it because most...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 3:12 am

#3791135
Reply To: Index Fragmentation

stevec883 wrote:
(so there is no "standard" practive, I agree)
I'm in the process of trying to create one. Some of it is rock solid and some of it is still a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 1:41 am

#3791126
Reply To: Report Server Load balanced issue with one server while accessing https:

Ah... I thought you were just talking about the individual servers.
If both servers are at TLs 1.2, then I don't have have another idea (well, unless 1.0/1.1 is still "available"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 27, 2020 at 12:27 am

#3791122
Reply To: Report Server Load balanced issue with one server while accessing https:

I have to ask, why do you think it's a problem to generate the error when the service is stopped?
Anyway, the one server that produces the error may have TLS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2020 at 10:32 pm

#3791118

Viewing 15 posts - 6,346 through 6,360 (of 59,101 total)