Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,306 through 4,320 (of 59,087 total)

Reply To: Which version of SQL should I use?

curtisharrington wrote:
Now I am using SQL to manage school data.
What are you currently using?
--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 28, 2021 at 11:29 pm

#3957637
Reply To: It's All About the Gratitude

You're way too humble. Of course, that's also a part of what makes you so good. 😀 Thanks for what you and the other heavy hitters 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)

November 28, 2021 at 5:52 am

#3957535
Reply To: It's All About the Gratitude

One of the things that I'm most thankful for is the community that has grown around SQL Server Central. I don't know where I'd be without this hub of knowledgeable...
--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 27, 2021 at 6:00 am

#3957381
Reply To: Upcoming contributor milestone

Likewise, you and Phil are the only ones on this thread that I've not yet met in person. Brent did a presentation for us several years back and a couple...
--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 27, 2021 at 5:31 am

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

Viewing 15 posts - 4,306 through 4,320 (of 59,087 total)