Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 59,072 total)

Reply To: Database list and the last access date

I just reran the code I posted on my production box and it's returning precisely (except I stripped the time off the "Last Accessed Date" output, which you can get...
--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)

March 22, 2021 at 3:22 pm

#3860845
Reply To: Why Doesn't Database Software Help Us?

skeleton567 wrote:
I firmly believe there is danger in the 'cookie-cutter' approach to systems which depend far too much on distant developers instead of hands-on awareness.
Heh... preach it, Brother!
skeleton567 wrote:
Is it...
--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)

March 22, 2021 at 2:59 pm

#3860842
Reply To: Why Doesn't Database Software Help Us?

Sergiy wrote:
I don't understand why you people are complaining about the lack of automated DB tuning.
You've been given Auto Index Tuning - don't you have enough of it?
Want more?
Heh... in...
--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)

March 22, 2021 at 2:41 pm

#3860838
Reply To: how to do the following operation while the tables under different schema?

This is one of those places where the first step should have been an online search for "sp_spaceused" to find the documentation on the subject. It's pretty explicit about having...
--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)

March 22, 2021 at 2:35 pm

#3860834
Reply To: Why Doesn't Database Software Help Us?

To be honest, I don't want anymore "help" from MS in managing databases. For example, their insistence on permanently implementing the equivalent of TF11117 on TempDB with no way 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)

March 21, 2021 at 9:00 pm

#3860581
Reply To: Statistics Update Frequency

Jackie Lowery wrote:
What's the best way to know which index statistics need to be updated on a daily basis? I currently update stats on Friday, but I've noticed SQL is updating...
--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)

March 19, 2021 at 12:39 pm

#3859927
Reply To: How to stop a user creating a new table

Rupster wrote:
Thanks.
I want the user to be able to insert, amend and delete records within tables, but not to be allowed to create or delete any tables.
How do I achieve...
--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)

March 18, 2021 at 6:09 pm

#3859600
Reply To: BCP - Export Query to Tab Delimited Text File

Mike01 wrote:
There are a few things wrong with you query. You need to use queryout to get that to work, but remember, that xp_CmdShell is actually shelling out to 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)

March 18, 2021 at 3:29 pm

#3859544
Reply To: Database list and the last access date
The SQL would look like the following... 😀
```
   WITH ctePreAgg AS
(--==== Pre-aggregate the relevant columns to make display easier.
 SELECT  DBName   ...
```
--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)
March 17, 2021 at 9:27 pm

#3859161
Reply To: Every IT Organization is a Snowflake

There are several different "broad categories" of real snowflakes. From what I've seen, each shop really is unique even if they fit one of the broad categories. To wit, 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)

March 17, 2021 at 2:23 am

#3858757
Reply To: Is there room for independent SQL or Data Integration based User Groups?

David Burrows wrote:
One advantage of virtual meetings would be, if permissible, for us this side of the pond attending. Would love to see you presenting Jeff 🙂
Lordy... I'm sorry, David... 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)

March 16, 2021 at 2:17 am

#3858291
Reply To: Help with non-clustered index fragmentation

rando wrote:
That seems to have done the trick. Thanks!
Be careful of "the trick". I may be causing unnecessary rebuild of the clustered index and a wad of non-clustered indexes, 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)

March 15, 2021 at 5:21 pm

#3858111
Reply To: Distributed SQL Databases

Sergiy wrote:
No code can fix performance issues caused by faulty database design.
If you think otherwise - try to fix performance (and scalability) issues on msdb.
I'll be the first to agree...
--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)

March 15, 2021 at 2:44 pm

#3858018
Reply To: Errors using XML value method

wrote:
However, that's true only when returning the entire XML value. The query() method retrieves a subset of untyped XML from the target XML instance. location within the document, 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)

March 15, 2021 at 6:23 am

#3857839
Reply To: Bulk Insert not working for dataset

logan.keister wrote:
Hello all,
Maybe this is my own ignorance showing, but I think I've hit a brick wall. I can't seem to bulk insert a dataset. I create a temp table...
--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)

March 15, 2021 at 1:18 am

#3857776

Viewing 15 posts - 5,476 through 5,490 (of 59,072 total)