Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,026 through 11,040 (of 59,099 total)

RE: Are the posted questions getting worse?

Shifting gears a bit... I've been forced into using O365... My initial impress is that the online version of Outlook sucks. You can't collapse the "Today", "Yesterday", "Last Week", etc,...
--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, 2018 at 1:15 pm

#2008593
RE: What Steps Woud You Take: Inserting 200,000 records

Jacob Pressures - Monday, October 8, 2018 9:10 AM
Hi Jeff,
Thanks for the information. I shared with my team lead.
She said:
--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, 2018 at 10:56 am

#2008578
RE: sp_RefreshSQLModule run on a view completely changed the view definition

I don't use sp_rename so I've not run into this but, good lord!!! What a land mine MS put into their code. Oh sure, it's "documented"...
--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, 2018 at 8:07 am

#2008544
RE: How to flip tables in sql server 2014

vikasjagadale8 - Sunday, October 7, 2018 12:34 AM
Jeff Moden - Friday, October 5, 2018 7:57 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, 2018 at 7:57 am

#2008540
RE: Large Transaction Log - Mostly Unused

mike 14496 - Monday, October 8, 2018 6:51 AM
Hello Everyone,
I have a 2014 database that has a data file which is almost...
--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, 2018 at 7:48 am

#2008538
RE: Find and replace third occurrence of the string

saravanatn - Sunday, October 7, 2018 11:55 AM
Jeff Moden - Sunday, October 7, 2018 11:31 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, 2018 at 2:09 pm

#2008478
RE: What Should You Look for in a SQL Monitoring Tool?

p.s. While performance may not be THE most important thing, I agree that you did touch on it's importance, I'd like to stress that it's very important and runs a very,...
--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, 2018 at 11:33 am

#2008468
RE: Find and replace third occurrence of the string

saravanatn - Saturday, October 6, 2018 11:29 PM
I want to find the third occurrence of the 'o' and replace with 'A'
[code...
--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, 2018 at 11:31 am

#2008467
RE: How To Create dynamic column in Sql

135heidari - Saturday, October 6, 2018 11:08 PM
Declare @ColumnName as Varchar(50)
declare @ssql nvarchar(200)
declare @dataType nvarchar(150)
Set @ColumnName ='Column1'
Set @dataType ='nvarchar(50)'
set @ssql = 'Alter...
--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, 2018 at 11:20 am

#2008466
RE: What Should You Look for in a SQL Monitoring Tool?

I've found that a whole lot of people that use monitoring tools use monitoring tools because they don't know how to monitor things themselves. Along with that lack of knowledge,...
--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, 2018 at 11:15 am

#2008464
RE: Performance concernce

Eirikur Eiriksson - Sunday, October 7, 2018 8:47 AM
vNext is more like vLast
😎
Ok, Eirikur... you owe me a new monitor AND...
--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, 2018 at 10:27 am

#2008460
RE: BCP issues with export data files generated with queryout won't import in tables.

shamshad.ali - Sunday, October 7, 2018 12:42 AM
TSV = Tab separated, CSV is comma separated, is this what you mean? It is...
--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, 2018 at 9:23 am

#2008458
RE: BCP column limit

All of this is precisely why it was a grievous error to start a second post on this, Satya. Please see my response on your other post. It will fix...
--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, 2018 at 9:00 am

#2008457
RE: Max size file in BCP process

SATYA R - Saturday, October 6, 2018 10:19 PM
Ok jeff,
I am trying to load same file in my local setup in 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)

October 7, 2018 at 8:47 am

#2008456
RE: Testing strings for multiple substrings

david_h_edmonds - Friday, October 5, 2018 5:53 AM
Hello all,
I am stuck with how to approach this task.
I have an error table 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)

October 6, 2018 at 8:46 pm

#2008439

Viewing 15 posts - 11,026 through 11,040 (of 59,099 total)