Jeff Moden

Forum Replies Created

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

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
RE: Consolidate Overlapping Datetimes

See the following article.
http://sqlmag.com/sql-server/new-solution-packing-intervals-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 26, 2017 at 4:50 pm

#1952926
RE: conbine outout

So do a row number with a partition by ID and a sort by date with a criteria of "not available" in a CTE and then select from the CTE...
--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:41 pm

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

cpeck - Wednesday, July 26, 2017 2:41 PM
I have synonyms created that point to a database on the same server. I have been...
--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 3:57 pm

#1952923
RE: SSMS is Free

Steve Jones - SSC Editor - Wednesday, July 26, 2017 8:52 AM
Yes and no. There still is a way:
--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 2:38 pm

#1952911

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