Jeff Moden

Forum Replies Created

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

RE: msdb data file shrinkfile - Large Database

sqlguy80 - Monday, September 11, 2017 7:12 AM
Imran,
Thank you so much, That worked! Your great.
Any logic behind that? I couldnt find...
--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 11, 2017 at 8:22 am

#1958931
RE: Query Help - Slow Performance

Considering the desired output, the real problem is that bloody student schedule table. It needs to be pre-aggregated to only the information required which will remove thousands and thousands 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)

September 11, 2017 at 7:42 am

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

caz100 - Monday, September 11, 2017 2:18 AM
@
--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 11, 2017 at 7:38 am

#1958922
RE: SQL Server Standard Competencies

Grant Fritchey - Friday, September 8, 2017 5:44 AM
I'm actually not a fan of the Microsoft Certifications, however, the skills they test...
--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 10:03 pm

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

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