Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,146 through 14,160 (of 59,101 total)

RE: Alter LDF File Max Size

Hi Chris,
Thanks for the handy query. Can you tell me what it means that the majority of my data is coming from .Net SqlClient...
--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)

October 9, 2017 at 5:28 pm

#1962922
RE: Delete DB, where physical files are missing

dan.brown1 - Monday, October 9, 2017 5:18 PM
Drop alone is not working and gives the same error.
Also, right click is giving 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)

October 9, 2017 at 5:19 pm

#1962921
RE: Delete DB, where physical files are missing

dan.brown1 - Monday, October 9, 2017 1:17 PM
Got a situation, the storage location where the physical DB files existing is been deleted...
--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)

October 9, 2017 at 3:45 pm

#1962910
RE: Alter LDF File Max Size

jstites - Monday, October 9, 2017 1:02 PM
Hi,
The product I support does a FULL backup nightly as well as log backup 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)

October 9, 2017 at 1:56 pm

#1962889
RE: Options to run BCP in SQL Server

sqlenthu 89358 - Monday, October 9, 2017 11:52 AM
Hi All, the question might be stupid but as a quick fix want 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)

October 9, 2017 at 1:43 pm

#1962885
RE: Comparing 2 functions for any differences in the result set.

p.s. I also asked if you would post both functions that you're testing so that we might be able to 1) understand more of your testing requirements so that we...
--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)

October 9, 2017 at 10:51 am

#1962863
RE: Comparing 2 functions for any differences in the result set.

ffarouqi - Monday, October 9, 2017 10:42 AM
TheCTEGuy - Friday, October 6, 2017 4:53 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)

October 9, 2017 at 10:46 am

#1962862
RE: The Worms-eye View

TomThomson - Wednesday, October 4, 2017 10:45 AM
Jeff Moden - Monday, October 2, 2017 9:59 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)

October 9, 2017 at 12:52 am

#1962783
RE: query format

MinhL7 - Sunday, October 8, 2017 3:19 PM
This is just dummy data to show how I need the data displayed in 3...
--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)

October 8, 2017 at 11:45 pm

#1962781
RE: query format

And what logic is supposed to change "Chef" to "Food Services"?
--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)

October 8, 2017 at 2:15 pm

#1962772
RE: IO and drive latency

coolchaitu - Sunday, October 8, 2017 7:24 AM
Jeff Moden - Sunday, October 8, 2017 7:19 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)

October 8, 2017 at 8:07 am

#1962757
RE: IO and drive latency

coolchaitu - Sunday, October 8, 2017 7:07 AM
Jeff Moden - Saturday, October 7, 2017 2:37 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)

October 8, 2017 at 7:19 am

#1962755
RE: Why SQL Server is Better Than Oracle

kannan_egd - Saturday, October 7, 2017 12:00 AM
Dear Jeff Moden,
Thanks for the response. The Drives provided by us are taken from two...
--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)

October 7, 2017 at 9:33 pm

#1962749
RE: SQl to calculate average time for call centre agents

Zalouncha - Saturday, October 7, 2017 1:37 AM
Jeff Moden - Saturday, October 7, 2017 1:22 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)

October 7, 2017 at 9:21 pm

#1962748
RE: Using Date in Where Condition

ChrisM@home - Saturday, October 7, 2017 3:25 PM
Phil Parkin - Saturday, October 7, 2017 9:47 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)

October 7, 2017 at 9:10 pm

#1962747

Viewing 15 posts - 14,146 through 14,160 (of 59,101 total)