Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,341 through 8,355 (of 59,091 total)

Reply To: Maintenance Window for SQL Server Critical Alerts

Heh... I just let the alerts fly... it's a great monthly test/confirmation for the alerts and the jobs that some of them run. The auditors love it because it shows...
--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 19, 2019 at 2:45 pm

#3698838
Reply To: Trigger store procedure with a file in SQL Server

You allow an app to write files to your SQL Server? I don't allow that. It have people write their files to a different box and then give SQL Server...
--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 19, 2019 at 2:39 pm

#3698835
Reply To: Why no posts?

xsevensinzx wrote:
I've been highly inactive for like a year it seems, but here is my input.
I am still 100% invested in Azure Data Warehouse and Azure Data Lake Store with...
--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 19, 2019 at 2:33 pm

#3698833
Reply To: missing storage space

Uh... I just noticed... the first script doesn't even report sizes... so I'm confused as to what you found the problem to actually be.
--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 19, 2019 at 2:26 pm

#3698828
Reply To: missing storage space

Just to confirm... Are you saying that the first script reported 155GB and that was what was incorrect?
--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 19, 2019 at 2:23 pm

#3698826
Reply To: Replace TABLE with STAGING_TABLE. Approach?

So, just to be sure, you're not going to use the code in the "All seems to be working now" post above?
--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 19, 2019 at 2:15 pm

#3698825
Reply To: It Just Works

call.copse wrote:
I've developed SQL backed Access front end databases that work with 40 odd users that have been going for many, many years and perform their function very reliably. 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 19, 2019 at 1:20 pm

#3698804
Reply To: It Just Works

sean redmond wrote:
For small operations, that is, fewer than 5 people using it concurrently, Access (or FileMaker Pro) is excellent. It's relatively cheap and easy for someone with some experience 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)

November 19, 2019 at 1:13 pm

#3698802
Reply To: Minimum memory

If you're going to cite an article, it would be polite to provide the link, as well,
Now... notice that the tip says IF your server has a lot 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)

November 19, 2019 at 5:13 am

#3698730
Reply To: Log file growth

Index rebuilds won't make a database go offline unless the logfile explodes large enough to fill the disk it's on.
Index rebuilds will make the table data unavailable (which will obviously...
--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 19, 2019 at 5:00 am

#3698728
Reply To: Minimum memory

I have to say that it probably won't do much for performance (if anything at all) but it may cause some memory pressure because you're doubling the minimum of every...
--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 19, 2019 at 4:52 am

#3698726
Reply To: Temporal tables - real world opinions?

Ok... just my 2 cents and, like you, I've not been using them for long and so I could still be missing a nasty caveat or two but, so far,...
--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 19, 2019 at 4:38 am

#3698723
Reply To: It Just Works

I think that a large part of the reason why Access won't die is because it has everything it needs and you don't actually have do any programming to use...
--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 19, 2019 at 1:21 am

#3698694
Reply To: I am new to SQL world
Kabina wrote:
Thom A wrote:
This is pseudo-SQL, but seems like you'd be better off with a start and end parameter, which you set at the start of the batch:
```
DECLARE...
```
--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 19, 2019 at 12:18 am

#3698677
Reply To: Help with determining formulas/processes for solving a problem?

jonathan.crawford wrote:
That sounds dangerous, simply because reduced availability will likely drive customers away, so the efficiencies that are assumed to be gained are really lost completely. Customers pay for their...
--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 19, 2019 at 12:12 am

#3698676

Viewing 15 posts - 8,341 through 8,355 (of 59,091 total)