Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,446 through 14,460 (of 59,097 total)

RE: Slow queries during busy times

Ah... almost forgot. Check your connection strings. If they enable MARS (Multiple Active Result Sets), turn that off NOW! It doesn't do what a lot of people think and should...
--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 4, 2017 at 9:27 am

#1958020
RE: Slow queries during busy times

Casper101 - Friday, September 1, 2017 12:56 AM
Hi,
Thank you for your feedback, and for confirming my suspicions....
I inherited this server so 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 4, 2017 at 9:22 am

#1958019
RE: Executing commands in SQLCMD

Ed Wagner - Monday, August 28, 2017 5:40 AM
TomThomson - Friday, August 25, 2017 5:41 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 4, 2017 at 7:10 am

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

poornima.s_pdi - Monday, September 4, 2017 3:39 AM
Hi,
I am using SQL Server 2012 Express Edition.
I need to automatically change the value 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 4, 2017 at 7:05 am

#1958003
RE: Filegroup status

NicHopper - Monday, September 4, 2017 2:55 AM
Hi,
Thanks for the table name, that worked a treat. For others this is how 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 4, 2017 at 6:40 am

#1958000
RE: Filegroup status

Check out sys.master_files. The data_space_id is the number for the filegroup. You'll also find a status in the "state" and "state_desc" columns. There is one entry for every file 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)

September 3, 2017 at 7:27 pm

#1957966
RE: splitting column into two

alhakimi - Sunday, September 3, 2017 1:26 PM
hmm , yes i found out that some names are without / , what should...
--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 3, 2017 at 7:09 pm

#1957965
RE: Need to remove punctuation characters

rhythmk - Friday, August 11, 2017 11:22 PM
Hi,
I need to remove any punctuation characters at the end and before new line.
Please help.
Ok......
--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 3, 2017 at 6:47 pm

#1957964
RE: Are the posted questions getting worse?

TomThomson - Saturday, September 2, 2017 7:17 PM
Sean Lange - Thursday, August 31, 2017 8:11 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 3, 2017 at 5:37 pm

#1957963
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

Concerning the update code you posted...
1. Both tables need to use the 2 part naming convention of schemaname.tablename.(Small performance gain + data safety/integrity).
2. The "TKey" and "ProcessDate" column...
--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 3, 2017 at 5:04 pm

#1957962
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Sunday, September 3, 2017 9:41 AM
Hi Jeff
Started saving performance monitor screenshots. I feel more confident after using it.
Here is 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 3, 2017 at 3:44 pm

#1957960
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

p.s. To save you some time, I've attached a file called "PerfMon.txt". After you upload it, change the name to "PerfMon.msc" and save it to the desktop of your 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)

September 2, 2017 at 9:51 pm

#1957947
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 1:40 PM
Jeff Moden - Saturday, September 2, 2017 11:10 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 2, 2017 at 9:21 pm

#1957945
RE: Database Development Made Easy?

Heh... I have a saying about designing databases... "If you think it was easy, you did something wrong". There are a lot of "standard" and "best practice" things that must...
--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 2, 2017 at 12:48 pm

#1957936
RE: Are the posted questions getting worse?

Neil Burton - Friday, September 1, 2017 8:10 AM
Beatrix Kiddo - Friday, September 1, 2017 7:44 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 2, 2017 at 12:12 pm

#1957933

Viewing 15 posts - 14,446 through 14,460 (of 59,097 total)