Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,021 through 13,035 (of 59,095 total)

RE: How do the Experts Become Experts?

Matt Miller (4) - Tuesday, January 30, 2018 10:00 AM
While I agree with the "wolves in sheeps clothing" type comments from Jeff,...
--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)

January 30, 2018 at 10:40 am

#1977910
RE: SQL Probe Bitmap 1008 high CPU

How many rows are actually in each 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)

January 30, 2018 at 6:52 am

#1977844
RE: Huge Latency in TempDB

Narine M - Tuesday, January 30, 2018 3:34 AM
Hi All,
We are facing a huge latency in tempdb, what will be the reason???
Latency
1174
1174
1166
1173
With...
--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)

January 30, 2018 at 6:32 am

#1977840
RE: How do the Experts Become Experts?

Unfortunately, many "experts" are considered to be experts simply because they publish very often or have written a book on a subject that happens to sell well because the people...
--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)

January 30, 2018 at 6:20 am

#1977839
RE: how to find if xp_cmdshell is being used or not

Sue_H - Monday, January 29, 2018 3:06 PM
ffarouqi - Monday, January 29, 2018 2:44 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)

January 30, 2018 at 5:28 am

#1977836
RE: Data migration from one database to multiple databases

banda.sai - Monday, January 29, 2018 4:27 AM
Hello,
There are millions of records in one database and expecting to migrate records from two or...
--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)

January 29, 2018 at 3:11 pm

#1977790
RE: how to find if xp_cmdshell is being used or not

ffarouqi - Monday, January 29, 2018 2:44 PM
Jeff Moden - Monday, January 29, 2018 2:30 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)

January 29, 2018 at 3:01 pm

#1977785
RE: INSERT running slow in SQL 2016

P.S. The Trace Flag that I'm talking about is 9481. Do Google it before you use 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)

January 29, 2018 at 2:55 pm

#1977782
RE: INSERT running slow in SQL 2016

coolchaitu - Wednesday, January 24, 2018 11:24 PM
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....
--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)

January 29, 2018 at 2:37 pm

#1977779
RE: how to find if xp_cmdshell is being used or not

ffarouqi - Monday, January 29, 2018 2:18 PM
I am trying to figure out if we can find out if xp_cmdshell is used...
--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)

January 29, 2018 at 2:30 pm

#1977777
RE: Refresh all views in a database

Heh... not only different schema but the quite different problem of a view that uses the WITH SCHEMABINDING directive. You might also want to think about NOT rebuilding Indexed Views...
--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)

January 29, 2018 at 10:46 am

#1977732
RE: Specified file is not a SQL Server backup file

RandomStream - Friday, January 26, 2018 4:56 PM
chrisr2 - Friday, January 26, 2018 4:14 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)

January 29, 2018 at 10:40 am

#1977730
RE: My database can't be opened

This thread has all the classic symptoms of something that will probably turn out to be spam. In the next day or two, someone will post a link to a...
--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)

January 29, 2018 at 10:32 am

#1977727
RE: how to get all values from one table repeated to each group on a column in another table

Naveen PK - Friday, January 26, 2018 1:54 PM
Updated Query tables:
I have a table called DisplayFields and another one called tax....
--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)

January 27, 2018 at 10:41 am

#1977629
RE: Changing Extensions

Steve Jones - SSC Editor - Thursday, January 25, 2018 8:52 PM
I'm going to disagree on #4. That might be preferable 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)

January 25, 2018 at 9:52 pm

#1977480

Viewing 15 posts - 13,021 through 13,035 (of 59,095 total)