Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,086 through 14,100 (of 59,095 total)

RE: SQL Server procedure to script tables

You should rewrite this as an article and submit it. They'll even throw you a couple of bucks for 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)

October 14, 2017 at 7:10 pm

#1963712
RE: Dead lock in production

Eirikur Eiriksson - Saturday, October 14, 2017 12:31 AM
The error log might give a hint but it is not enough information 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 14, 2017 at 6:48 pm

#1963711
RE: bcp import data from text file to sql server table - german accent

p.s. You do realize that you don't need to use BCP just because you're using a format file, correct? BULK INSERT in T-SQL will work just fine if you don't...
--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 14, 2017 at 6:42 pm

#1963710
RE: bcp import data from text file to sql server table - german accent

Change the length of the 3rd field in the BCP Format File from 5 to 7. The reason is that you're trying to import by fixed field length, which also...
--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 14, 2017 at 6:39 pm

#1963709
RE: Are the posted questions getting worse?

Thom A - Saturday, October 14, 2017 2:11 PM
And we're done! Whoop whoop!
Surprisingly went smoothly, and didn't end as a midnighter. 😀
When...
--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 14, 2017 at 5:36 pm

#1963708
RE: Are the posted questions getting worse?

Phil Parkin - Saturday, October 14, 2017 7:24 AM
Thom A - Saturday, October 14, 2017 2: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)

October 14, 2017 at 5:35 pm

#1963707
RE: calculation

adisql - Saturday, October 14, 2017 12:59 PM
Jeff Moden - Saturday, October 14, 2017 9:16 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 14, 2017 at 5:32 pm

#1963706
RE: Creating a Gantt Chart using SQL?

SteveOC - Saturday, October 7, 2017 5:23 AM
Hello.
I am trying to develop the concept of a report of utilization of barcode scanning...
--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 14, 2017 at 10:29 am

#1963694
RE: TSQL help on strings

Luis Cazares - Friday, October 13, 2017 1:49 PM
Actually, I think that the solution is something as the one presented here:
--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 14, 2017 at 10:18 am

#1963693
RE: calculation

adisql - Friday, October 13, 2017 8:56 PM
Jeff Moden - Friday, October 13, 2017 8:16 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 14, 2017 at 9:16 am

#1963692
RE: Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?

Jason A. Long - Saturday, October 14, 2017 6:27 AM
Steve, would something like this work for you? Kinda of "Quirky Splitter"... 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)

October 14, 2017 at 8:57 am

#1963691
RE: Incremental load solution to track the changes

ramrajan - Friday, October 13, 2017 1:26 AM
Loading the data 70 Million records from IBM DB2 to SQL Server
Problem â€“
1. Need...
--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 13, 2017 at 9:44 pm

#1963672
RE: Query similar to wireshark

saum70 - Monday, October 9, 2017 8:11 AM
Hi,
We intend to write a query that will act like wireshark i.e. note down which...
--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 13, 2017 at 9:20 pm

#1963671
RE: Require help with creating a view with YTD balances and period

SQL_beginner1 - Friday, October 13, 2017 9:25 AM
Lynn and Steve,
Thanks for your replies. I made it work by moving the view2-related filters...
--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 13, 2017 at 8:51 pm

#1963669
RE: SQL server service account is locking out

G Sunny - Thursday, October 12, 2017 3:18 PM
Hi,
we are seeing one of our service account getting locked out for every fifteen...
--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 13, 2017 at 8:48 pm

#1963668

Viewing 15 posts - 14,086 through 14,100 (of 59,095 total)