Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,336 through 7,350 (of 59,072 total)

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

Saravanan_tvr wrote:
When you have lot of budget then we will prefer the consultant, but handling sql 7.0 to till 2017 we need to take over this with being backup 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 8, 2020 at 2:25 pm

#3741442
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: Going Back to the Basics

And there the man is! 😀 Go for it, Scott!
--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:09 pm

#3740848
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

Viewing 15 posts - 7,336 through 7,350 (of 59,072 total)