Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,366 through 7,380 (of 59,098 total)

Reply To: Need T-SQL to list all tables in database that 'qualify' for Compression

VoldemarG wrote:
oh well.
Should I not even bother compressing non-clustered indexes?
what if my table does not have clustered indexes? it only has a composite primary key, non-clustered. And a dozen of...
--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)

April 7, 2020 at 11:08 pm

#3741249
Reply To: Iterating Over Calculated Tables using Power Query

I can't comment much about your good article other than it seems well laid out and produces the correct order of revelation. So nice job there.
I'll also state that I...
--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)

April 7, 2020 at 9:12 pm

#3741214
Reply To: Daily Coping Tip 3 Apr 2020

I have a tip... Download the Developer's Edition of T-SQL, a copy of SQL Server "Books Online", and start teaching yourself more about SQL Server so that when you do...
--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)

April 7, 2020 at 4:16 pm

#3741108
Reply To: Permissions to Run CLR Assembly

What would be more interesting is what the CLR assemblies actually do. A lot of people resort to CLR simply because they don't know how to do something in T-SQL. ...
--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)

April 7, 2020 at 4:05 pm

#3741099
Reply To: bcp format file and import fixed width text file

smattiko83 wrote:
I'm trying to set up a format file using bcp but I'm unsure of how to set it up.
I used "bcp de_identified.dbo.test format -c -t -f c:\sql\test3.fmt -T" 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)

April 7, 2020 at 4:02 pm

#3741094
Reply To: Partitioning table techniques which one is best way?

A trillion row table and you folks have no previous experience with partitioning. My recommendation is that you don't try this on your own. Get a consultant that really knows...
--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)

April 7, 2020 at 3:29 pm

#3741074
Reply To: Execute permission on a function

evaz wrote:
Thank you all!
I have asked and they are sorting it out 🙂

Excellent! I have found that "The answer is always 'NO'... unless you ask". 😀
--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)

April 7, 2020 at 3:17 pm

#3741071
Reply To: Why/when should I choose Row level compression over Page compression?

VoldemarG wrote:
In what table design/scenarios should I prefer a Row level compression and not Page level?
Like if we were to name one major advantage of one over another, and possibly...
--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)

April 7, 2020 at 3:14 pm

#3741070
Reply To: Need T-SQL to list all tables in database that 'qualify' for Compression

VoldemarG wrote:
THANKS!
Question: can there be any reason that an error will be thrown while attempting to compress the table? Like what should be 'wrong' with table to cause the compression...
--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)

April 7, 2020 at 5:22 am

#3740948
Reply To: insert random value from predefined list of possible values

I'm sorry... I forgot to add that you can get the fnTally function from the similarly named link in my signature lines below.
--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)

April 6, 2020 at 9:26 pm

#3740901
Reply To: insert random value from predefined list of possible values
That's a little different. I thought you said random "values", not "strings". Of course, you could convert the following to strings.
```
--===== Create the list of the first...
```
--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)
April 6, 2020 at 6:54 pm

#3740866
Reply To: insert random value from predefined list of possible values

marchello wrote:
Hi all,
My need is to insert random value from predefined list of possible values. It's data obfuscation project, thus no strict rules what value should be, rather it should...
--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)

April 6, 2020 at 6:36 pm

#3740862
Reply To: Execute permission on a function

You need to contact the people in charge of providing the necessary permissions.
--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)

April 6, 2020 at 3:11 pm

#3740780
Reply To: Advantages and Disadvantage using Temp Table or Fisical Table
Your indexes on the temp tables are still incorrect. You're joining them by ID, not col1 and col2. And, they should be Clustered Indexes. At least that's why I see...
- This reply was modified 6 years, 6 months ago by Jeff Moden.
--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)
April 6, 2020 at 2:59 pm

#3740773
Reply To: Advantages and Disadvantage using Temp Table or Fisical Table

Have you ever tried to shoot an arrow through the hole of a donut rolling down a hill from a quarter mile away? That's how I'm starting to feel with...
--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)

April 6, 2020 at 2:34 pm

#3740765

Viewing 15 posts - 7,366 through 7,380 (of 59,098 total)