Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,356 through 14,370 (of 59,097 total)

RE: SQL Server Standard Competencies

Please don't double post. It just splits up the answers and wastes people's time.
Every please see the active link below for this question. Thanks.
https://www.sqlservercentral.com/Forums/1896075/SQL-Server-Standard-Competencies
--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)

September 10, 2017 at 9:51 pm

#1958891
RE: SQL Server Standard Competencies

Deni Kusdeni - Friday, September 8, 2017 3:26 AM
We want to hire people who have SQL Server skill, does anyone having standard...
--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)

September 10, 2017 at 9:51 pm

#1958890
RE: To automatically change the value of a column if a particular date time is reached

poornima.s_pdi - Sunday, September 10, 2017 7:52 PM
Thanks for all.
Those suggested and guided me in the right direction to use windows...
--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)

September 10, 2017 at 9:43 pm

#1958889
RE: Query Help - Slow Performance

bateman_aaron - Sunday, September 10, 2017 8:38 PM
Jeff Moden - Sunday, September 10, 2017 6:41 PM
--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)

September 10, 2017 at 9:41 pm

#1958888
RE: msdb data file shrinkfile - Large Database

What command(s) are you using to shrink the files? If you're using the GUI, what options are you setting?
--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)

September 10, 2017 at 9:37 pm

#1958887
RE: difficult (for me) query to count available items

burfos - Thursday, September 7, 2017 2:41 AM
AND AllBookingsWithItems.start_date < MyBooking.end_date
AND AllBookingsWithItems.end_date > MyBooking.start_date
[/code]
+1 to 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)

September 10, 2017 at 8:11 pm

#1958882
RE: msdb data file shrinkfile - Large Database

sqlguy80 - Sunday, September 10, 2017 6:44 PM
Hi ,
The msdb data file on a prod db server is 6 GB, Though 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)

September 10, 2017 at 8:04 pm

#1958881
RE: Hardening windows AD account running sqlserver service and sql agent / and or changing the password

caz100 - Friday, September 8, 2017 6:58 AM
@arsh-2 - Thanks but for the second question passwords are already set to never expire....
--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)

September 10, 2017 at 7:36 pm

#1958878
RE: Query Help - Slow Performance

bateman_aaron - Sunday, September 10, 2017 4:49 PM
Understood. When I ran the query analyzer it gave 0 suggestions for indexes. As 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)

September 10, 2017 at 6:41 pm

#1958876
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Sunday, September 10, 2017 4:03 AM
Jeff Moden - Saturday, September 9, 2017 4:17 PM
--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)

September 10, 2017 at 1:31 pm

#1958867
RE: Are the posted questions getting worse?

Wow... the spam seems worse now than ever, especially over the weekends/Friday nights. I thought there was supposed to be some sort of AI spam detector that would eliminate 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)

September 9, 2017 at 4:17 pm

#1958852
RE: Stalled Query?

alex.sqldba - Saturday, September 9, 2017 12:28 PM
Jeff, (and others),
I've not go to testing this yet but just had the thought: would...
--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)

September 9, 2017 at 4:13 pm

#1958851
RE: Newbie - simple Query Question - function

Recommend you use CHAR(4) instead of VARCHAR(4). Right sizing and using the right datatype is a good habit to get into. VARCHAR(4) actually takes 6 bytes (4 for data, 2...
--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)

September 9, 2017 at 10:14 am

#1958849
RE: Powershell SMO - LastBackupDate without Copy_only Backup

Satheesh E.P. - Saturday, September 9, 2017 8:07 AM
@jeff Moden
I need to restore 7 databases from 5 different production servers and restore...
--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)

September 9, 2017 at 9:40 am

#1958848
RE: Determine Monday of next month and Monday of next week

jcelko212 32090 - Friday, September 8, 2017 2:23 PM
I think you missed the point. Those were display formats, not internal storage...
--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)

September 8, 2017 at 9:56 pm

#1958832

Viewing 15 posts - 14,356 through 14,370 (of 59,097 total)