Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,826 through 6,840 (of 59,091 total)

Reply To: Enable normal user to execute a sys stored procedure

To be blunt, there is no way in hell I'd give a "normal" user the privs to do anything with roles indirectly never mind directly. If such functionality is required,...
--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)

July 7, 2020 at 4:45 pm

#3768125
Reply To: Limitation on a file size import

@cbrammer1219 ,
Asking the question again, WHAT are you using to do the imports and from where?
--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)

July 7, 2020 at 4:40 pm

#3768124
Reply To: spill to tempdb problem

zamani 41951 wrote:
Jonathan AC Roberts wrote:
zamani 41951 wrote:
Hi
Thanks a lot.
I've run your edited query. but its cost was 51% against last improved query that I sent in my last post. And Logical Read grows...
--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)

July 7, 2020 at 4:34 pm

#3768122
Reply To: Limitation on a file size import

Jeffrey Williams wrote:
You also have to be aware of transaction log usage - if you import a large file in a single batch you will need at least that much space...
--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)

July 6, 2020 at 9:55 pm

#3767840
Reply To: Limitation on a file size import

cbrammer1219 wrote:
Is there a restriction of file size that can be imported into SQL? 5 gig, 10 gig???
Are you running into any problems right now?
--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)

July 6, 2020 at 9:50 pm

#3767839
Reply To: Adding NOT NULL to column with existing rows causes page bloat

timoq wrote:
I am not privy to why the "simple act of redefining the column as NOT NULL adds 10 bytes" are "perfectly explainable". Please do. 🙂 I mean the column...
--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)

July 6, 2020 at 9:14 pm

#3767830
Reply To: stored procedure to delete user and login

I'd also recommend scripting out the login and all related users in all databases so that when you actually do (and you will sometime) crush a user in such 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)

July 6, 2020 at 4:17 pm

#3767746
Reply To: Using two different backup products for each of data and log

Fal wrote:
The recommendation to use 1 system overall was overruled.
I know you already know this but I have to say it out loud (and it's NOT aimed at you... you're...
--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)

July 6, 2020 at 3:14 pm

#3767733
Reply To: Adding NOT NULL to column with existing rows causes page bloat

Based on what I'm seeing, the index is rebuilt AFTER the data is added to the new column and the simple act of redefining the column as NOT NULL adds...
--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)

July 6, 2020 at 4:41 am

#3767612
Reply To: Retraining the World

It is nice to see a company stepping up to try to help so many people. I truly hope it works and I truly hope it doesn't turn out to...
--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)

July 6, 2020 at 1:39 am

#3767600
Reply To: is Clustered Columnstore index UNIQUE by default?

Such an easy thing for you to try to find out. 😉

--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)

July 6, 2020 at 1:11 am

#3767594
Reply To: Beginner needing help

AXPRRF wrote:
Removing post
Lordy... I hope you got it. If you'd shown that you tried, you might have gotten some help.
--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)

July 6, 2020 at 1:09 am

#3767593
Reply To: Pintable into cache

mtz676 wrote:
Thank you but my question was can caching/pinning tables be an option to avoid fragmentation ?
Maybe but I don't believe that even In-Memory tables with delayed durability will help...
--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)

July 5, 2020 at 6:21 pm

#3767570
Reply To: Connecting To Quickbooks via SSIS

It's been a long time since I've done it (circa 2000) but I believe that QuickBooks still has an export bit of functionality and a CLI to support it. Why...
--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)

July 5, 2020 at 4:23 am

#3767527
Reply To: Administrating Analysts

There's several ways to skin this cat... Write good stored procedures and distribute "refreshable" spreadsheets that call them or pre-aggregate the data as tab separated information and let the spreadsheet...
--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)

July 5, 2020 at 4:19 am

#3767526

Viewing 15 posts - 6,826 through 6,840 (of 59,091 total)