Jeff Moden

Forum Replies Created

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

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
RE: Testing strings for multiple substrings

Joe Torre - Friday, October 5, 2018 3:05 PM
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql?view=sql-server-2017
Ok, Joe. Let's say you took the time to setup FTS. What would...
--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:45 pm

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

shamshad.ali - Friday, October 5, 2018 8:47 PM
As mentioned earlier, I have to provide a solution in c# application which can accept...
--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:30 pm

#2008437
RE: Understanding the numeric and decimal data types

You might want to have a look at the following.
Precision, scale, and Length (Transact-SQL)
--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:18 pm

#2008436
RE: Remember the Simple Things

I wish people would remember the simple things when they're writing code. To me, the "KISS" method is "Keep It Super Simple".
--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:12 pm

#2008435

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