Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,781 through 9,795 (of 59,099 total)

RE: The SQL Saturday Thread

I guess a whole lot of people like dashboards (and monitoring systems, for that matter) for such things. I'm not one of them. Some show too much and some 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)

February 22, 2019 at 11:28 am

#2022678
RE: Failed to initialize sqlcmd library with error number -2147467259

You might have better luck getting an answer if you did the translation to English.
--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)

February 20, 2019 at 8:31 am

#2022483
RE: Using Dynamic SQL to create a list

I don't understand why you simply don't validate the data before you concatenate 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)

February 20, 2019 at 7:01 am

#2022470
RE: The SQL Saturday Thread

Ray K - Tuesday, February 19, 2019 8:24 AM
Ed Wagner - Tuesday, February 19, 2019 8: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)

February 20, 2019 at 6:22 am

#2022469
RE: Find text in sql modules

Peter Shilovich - Wednesday, February 20, 2019 3:06 AM
tamirgerber - Wednesday, February 20, 2019 2:05 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)

February 20, 2019 at 6:12 am

#2022468
RE: Find text in sql modules

tamirgerber - Wednesday, February 20, 2019 2:05 AM
Jeff Moden - Tuesday, February 19, 2019 9:58 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)

February 20, 2019 at 6:10 am

#2022467
RE: Find text in sql modules

tamirgerber - Tuesday, February 19, 2019 6:51 PM
One could use sp_msForEachDB builtin stored procedure. No cursor, no loop, and less chance 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)

February 19, 2019 at 9:58 pm

#2022449
RE: Diskspace requirement for 1M records

DBA_007 - Tuesday, February 19, 2019 12:58 PM
Thanks all,Can you explain with an example
--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)

February 19, 2019 at 9:14 pm

#2022447
RE: Diskspace requirement for 1M records

Sorry... posted on the wrong thread.
--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)

February 19, 2019 at 7:23 pm

#2022446
RE: removed zeroes from numeric column

Mike01 - Tuesday, February 19, 2019 10:48 AM
C'mon Jeff. Now you're just teasing everybody 😉
Crud... that's certainly not my intention. 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)

February 19, 2019 at 6:58 pm

#2022445
RE: BCP usage

Raghavender Chavva - Tuesday, February 19, 2019 8:34 AM
Even I have tried with .txt file also. Still below error:
Starting copy...
SQLState = 22001,...
--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)

February 19, 2019 at 6:56 pm

#2022444
RE: BCP usage

If you want to be able to import Excel data directly into a table in SQL Server, you need to install the ACE drivers on your SQL Server and then...
--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)

February 19, 2019 at 7:28 am

#2022367
RE: BCP usage

Raghavender Chavva - Tuesday, February 19, 2019 6:59 AM
Hi All,
I am trying to one bcp command I am not able to execute...
--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)

February 19, 2019 at 7:23 am

#2022366
RE: Performance Issue Problem in Stored Procedure

saravanan.a 88885 - Tuesday, February 19, 2019 3:13 AM
Hi All,
After google "Parameter Sniffing" i got 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)

February 19, 2019 at 6:24 am

#2022364
RE: removed zeroes from numeric column

frederico_fonseca - Tuesday, February 19, 2019 1:54 AM
Saurabh.D - Monday, February 18, 2019 11:25 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)

February 19, 2019 at 6:12 am

#2022361

Viewing 15 posts - 9,781 through 9,795 (of 59,099 total)