Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,671 through 14,685 (of 59,101 total)

RE: SQLCMD and Batch File magic

As a bit of a sidebar, I'd never use a user name and password to connect to the server because they leave your stuff in a batch file in clear...
--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)

July 29, 2017 at 11:53 am

#1953288
RE: SQLCMD and Batch File magic

schleep - Thursday, November 19, 2015 6:03 AM
Try this in Powershell: this basic functionality is relatively simple to learn.You'll never go back...
--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)

July 29, 2017 at 11:43 am

#1953287
RE: Synonyms causing performance issue - database on same server

Heh... it's always the code. 😉 Thanks for the feedback. I just couldn't imagine it being the simple use of synonyms that was causing the problem.
--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)

July 29, 2017 at 10:27 am

#1953285
RE: Powershell script transfers entire directory?

Brandie Tarvin - Thursday, July 27, 2017 5:33 AM
Jeff Moden - Monday, July 24, 2017 7:23 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)

July 29, 2017 at 10:24 am

#1953284
RE: how to deploy 10 T-SQL scripts across 200 databases

sqlguy80 - Friday, July 28, 2017 9:00 PM
Jeff Moden - Tuesday, July 25, 2017 3: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)

July 29, 2017 at 8:48 am

#1953282
RE: Timeouts Popping Up for Production Database

Seggerman-675349 - Saturday, July 29, 2017 6:01 AM
I'll have to check with the previous developer - it may be necessary for some...
--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)

July 29, 2017 at 8:42 am

#1953281
RE: Who's Smarter? Humans or AI Systems?

Steve Jones - SSC Editor - Thursday, July 27, 2017 11:37 AM
allinadazework - Thursday, July 27, 2017...
--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)

July 28, 2017 at 3:57 pm

#1953257
RE: Timeouts Popping Up for Production Database

I absolutely agree that keeping stats up to date is uber important but there's one other thing to check... make sure that the connection strings used by anything and everything...
--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)

July 28, 2017 at 3:46 pm

#1953256
RE: Where to put the historical data?

john.mcginley - Monday, July 24, 2017 2:40 PM
Table partitioning would be the "A" answer here but we can't do that with Standard...
--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)

July 28, 2017 at 11:03 am

#1953227
RE: BCP error -Unable to open BCP host data-file

BCP works fine with UNC's, as well. Don't use your server as a download repository even for staging a table.
--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)

July 27, 2017 at 1:54 pm

#1953104
RE: Synonyms causing performance issue - database on same server

Another question... has someone made the mistake of pointing the synonyms to a linked server?
--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)

July 27, 2017 at 1:44 pm

#1953101
RE: Career

super48 - Sunday, July 16, 2017 4:32 AM
Hi i have total 5 year exp.
4years in SSRS and SQL
3years ssis.
1 year in SSAs.
I...
--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)

July 26, 2017 at 5:19 pm

#1952931
RE: Cursor Performance

Thanks for all the replies. Problems with query store is that it fills up in minutes... (2GB query store). Anyway the vendor has provided a patch fix for...
--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)

July 26, 2017 at 5:13 pm

#1952930
RE: what should i do to become a DBA

raviveesha - Saturday, August 29, 2009 12:15 AM
hi,Can anybody suggest me what are the steps i should take to become dba.is 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)

July 26, 2017 at 5:05 pm

#1952928
RE: Getting NULL Values after execution using sp_executesql

SQL-DBA-01 - Wednesday, July 26, 2017 12:27 PM
Alright. I just fixed it.
Two way street here... So what did you end up doing?
--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)

July 26, 2017 at 4:54 pm

#1952927

Viewing 15 posts - 14,671 through 14,685 (of 59,101 total)