Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 59,098 total)

Reply To: Upcoming contributor milestone

Heh. Thanks for the notice, Aaron, but those points are a bit bogus and a left over from times long gone when LIKEs and other forms of upvotes just seemed...
--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)

November 25, 2021 at 6:37 am

#3956739
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS

Man, I thought we might have had it with the RCSI thing. You've answered all the other questions with the graphics. I see absolutely nothing in any of that that...
--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)

November 25, 2021 at 4:28 am

#3956705
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS

Weegee71 wrote:
Hi Jeff
Apologies for delaying in replying. Ive been ill with a bad cold .
This is what I see of the the table when i run sp_help 'dbo.SIData_222222_88_20211103_1436'
At least it's...
--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)

November 25, 2021 at 4:17 am

#3956704
Reply To: Alternative to CURSOR object
Arsh wrote:
Dear Friends,
Would be great if you can advise on an alternative to CURSOR object. Thank you in advance..
Best Regards...Arshad
1. Tally/Numbers Table
2. Tally/Numbers Inline function.
3. Other "Pseudo-Cursors" based on "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)
November 24, 2021 at 7:37 pm

#3956630
Reply To: sp_xml_removedocument

I agree with Grant...I wouldn't bother with DTA at all. It is actually possible to get such an error simply because of an overly complex query or a simple looking...
--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)

November 24, 2021 at 7:17 pm

#3956621
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
Right now, after you've uploaded (imported) a file to a named table, what do you want done with the file?
Once the files are uploaded, there are there...
--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)

November 24, 2021 at 7:08 pm

#3956618
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS
frederico_fonseca wrote:
Jeff Moden wrote:
Here's the next thing that could be a possibility... Run this code in the database where the table is at.
```
 SELECT is_read_committed_snapshot_on
   FROM...
```
--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)
November 24, 2021 at 7:00 pm

#3956617
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS
Here's the next thing that could be a possibility... Run this code in the database where the table is at.
```
 SELECT is_read_committed_snapshot_on
   FROM sys.databases 
...
```
--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)
November 24, 2021 at 4:27 am

#3956331
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS

Crud, I went to hit "Reply" on one of the posts above and hit "Report", instead. I've sent the WebMaster a request to undo that.
In the mean time, I have...
--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)

November 24, 2021 at 4:06 am

#3956315
Reply To: Creating Views - SQL School Video

Jeff Moden wrote:
What a great set of "mini-courses" you're in the process of having published! Nicely done! My only question on this one would be... why would you ever teach anyone...
--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)

November 23, 2021 at 9:03 pm

#3956229
Reply To: Why is the MS calculation for SQL Server table size not reflect Storage in SSMS

Because you didn't follow the instructions in the write-up for when to round down, your final value of 193MB is off by abou 10MB. It should have been 183.398438 MB.
That,...
--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)

November 22, 2021 at 8:25 pm

#3955793
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
Thanks Jeff
I haven't heard of ACE driver. Is it a tool ? if so, can you share a link please. I am not sure how to use bulk insert...
--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)

November 22, 2021 at 5:03 pm

#3955733
Reply To: Truncate vs Delete for Bulk Removal of (some not all ) records

simon_s wrote:
Unfortunately I dont have the space to test (create a duplicate db/table ), the whole rationale for this exercise is diskspace is full 🙁 , nor can I take...
--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)

November 22, 2021 at 4:53 pm

#3955724
Reply To: How to add top 1 row as header on SQL server as extra row ?

WHY do you need to do this?
--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)

November 22, 2021 at 4:15 pm

#3955706
Reply To: find which field and table blank or null field

Sorry. Post removed. I looked at the code and read it incorrectly.
--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)

November 22, 2021 at 4:03 pm

#3955703

Viewing 15 posts - 4,321 through 4,335 (of 59,098 total)