Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 59,099 total)

Reply To: What does date show?

To continue the math behind all of this and what the verbal description of what the code actually does, run the following code and let me know what number 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)

January 19, 2023 at 11:45 pm

#4139778
Reply To: What does date show?

Remember what I said about the DW datepart and DATEFIRST? What happens to the output when you change DATEFIRST and how does it relate to DATEFIRST insofar as the first...
--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)

January 19, 2023 at 11:42 pm

#4139777
Reply To: What does date show?

Don't apologize for the question. You got a good part of it right. Just not the "fine point". Very specifically, which part of last week does it ALWAYS show?
--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)

January 19, 2023 at 11:40 pm

#4139775
Reply To: What does date show?

Gosh, Jeremy. Put a SELECT on it, run it, and see. If you can't guess that, then break out pieces and see what it comes up with for values. If...
--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)

January 19, 2023 at 11:10 pm

#4139772
Reply To: No experience with programming; how difficult is SQL for new prospect?

seanachim@hotmail.com wrote:
I would STRONGLY suggest attending the Querying SQL Course.
When I do a search for "Querying SQL Course", I get a ton of returns from different sites and none 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)

January 19, 2023 at 10:11 pm

#4139758
Reply To: SQL on Hyperv

Jo wrote:
In reponse to Jo
I agree with Jeff, the applications seems to use a single connection sequentially.
So if i understand correctly, within the software, when they launch a query, 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)

January 19, 2023 at 9:54 pm

#4139753
Reply To: 10 years as Sql server dba but still fears of Interview and lack of Confidence

anoop.mig29 wrote:
Jeff Moden wrote:
anoop.mig29 wrote:
Hi jeff thanks for advice , i went by website you suggested geeks for geeks and i found it to more for programmers . .I didnt...
--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)

January 19, 2023 at 9:47 pm

#4139750
Reply To: Troubles with in memory OLTP performance degradation

Steve Jones - SSC Editor wrote:
To your points: - shut down vm at night - makes perfect sense, worth just doing this for cost reasons.
If such a savings makes such shutdowns "worth doing", you...
--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)

January 18, 2023 at 10:41 pm

#4139234
Reply To: When does the AWS Free Tier ACTUALLY expire?

wrote:
Hello. I keep reading that to check the expiration date for the AWS Free Tier, you need to check the first month that appears in your "Billing" section. Problem...
--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)

January 18, 2023 at 10:23 pm

#4139219
Reply To: The Temp Alias

Jason A. Long wrote:
You could create a separate stored procedure that accepts a spid as an input parameter. The stored proc would be a simple WAITFOR command that waits for a period...
--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)

January 18, 2023 at 2:17 am

#4138845
Reply To: SQL on Hyperv

Jo wrote:
Then there is still the cpu 'topping' issue. We can not comprehend that the cpu cuts off at 12.5%. spot on 12.5% (the limit?)
You said you have 8 CPUs. ...
--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)

January 17, 2023 at 11:44 pm

#4138804
Reply To: Can I set timeout for a query?

oRBIT wrote:
I mean within the SQL itself. Assume something like this fictional code:
IF (condition...) BEGIN
SET EXECUTION_TIMEOUT=1000 SELECT * FROM dbo.VeryLargeTable -- If the above select-statment takes more than 1000ms 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)

January 17, 2023 at 11:38 pm

#4138803
Reply To: Incorrect syntax near the keyword 'on'.

I also missed the leading wildcards in the criteria... be advised that will cause a full-scan of the table/index. No index seek will be possible.
--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)

January 17, 2023 at 8:43 pm

#4138756
Reply To: Incorrect syntax near the keyword 'on'.

It looks like many of your ONs should be ANDs, instead.
--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)

January 17, 2023 at 7:43 pm

#4138734
Reply To: Remove a Filegroup

amy.walsh wrote:
You might not be able to drop the filegroup because something still remains on it. Here are a couple of queries copied from other locations on the internet 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)

January 16, 2023 at 7:53 pm

#4138309

Viewing 15 posts - 2,116 through 2,130 (of 59,099 total)