Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,956 through 17,970 (of 59,069 total)

RE: Code smells versus transgressions

Shifting gears to your other question, yes, there are a whole lot of other "code smells" but one of the biggest code smells is the formatting of the code itself...
--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)

April 2, 2016 at 10:05 am

#1869319
RE: Code smells versus transgressions

From the article:
...and I've never found a good use for SQLVARIANT in a production table column. Am I wrong?
Not much but, yes... kind of and only if you believe in...
--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)

April 2, 2016 at 9:54 am

#1869317
RE: Where to start?

maylar (4/1/2016)
I've just installed SQL Server Express 2014 on my development machine, and I'm looking at the Management Studio Object Explorer. It's a bit daunting and not really intuitive. 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)

April 2, 2016 at 9:16 am

#1869312
RE: Protecting sa

Yet Another DBA (3/30/2016)
I tend to use a GUID for the password. Simple, straightforward and has approximately 5,300,000,000,000,000,000,000,000,000,000,000,000-ish combinations.
Only issue is to remember which post-it-note it was :rolleyes:
I did...
--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)

April 2, 2016 at 9:12 am

#1869311
RE: Suggestions for NIC Configurations?

dajonx (4/1/2016)
Hi,
I am trying to get all my ducks in a row before I upgrade the prod servers and transition from SQL Server 2008 R2 to SQL Server 2016 when...
--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)

April 2, 2016 at 9:04 am

#1869309
RE: Convert a string with an array of variables?

I'm going to recommend that anyone using this "numbering" system have a very large bank account and a good lawyer. It's amazing how offense some of the words 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)

April 1, 2016 at 10:51 pm

#1869292
RE: EXPLAIN - compare before and after Statistics

Glad you explained. "EXPLAIN PLAN" is an Oracle term, as well. I think they might be losing 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)

April 1, 2016 at 9:55 pm

#1869289
RE: Need help with shrink

How big are the log files and what do you want to shrink them to?
--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)

April 1, 2016 at 9:53 pm

#1869288
RE: Proper and careful use of a global temp table (##temp) First time I am using

You posted this in the 7/2000 forum and I'm assuming that 2000 is the version you have?
If so, the partitioning the table to take advantage of SWITCH-in is not possible....
--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)

April 1, 2016 at 9:51 pm

#1869287
RE: How To Format Phone Number

😀 Can't beat 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)

April 1, 2016 at 9:14 pm

#1869283
RE: SSIS connectivity logging into a SQL table

sqlnewbie17 (4/1/2016)
I have a list of 150 sqlservers.I need to build an SSIS package which will test connectivity
to the servers and if the connection is good the servername is inserted...
--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)

April 1, 2016 at 8:54 pm

#1869282
RE: Continuous Delivery In Real Life

jckfla (7/20/2015)
Seems to me, a lot of the changes being pushed out so fast in tech now aren't doing anything significant. There are exceptions, but the vast majority are either...
--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)

April 1, 2016 at 8:48 pm

#1869281
RE: Restore help needed for 1.5 TB database.

EdVassie (4/1/2016)
This means your filegroup backups can run in parallel. When you do a restore each filegroup can be restored in parallel, with greater parallelism given from the striping.
If they're...
--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)

April 1, 2016 at 8:27 pm

#1869280
RE: How do I Avoid Deadlocks?

Seggerman-675349 (4/1/2016)
on behalf of my client - thanks all
the process already makes most of its updates to a staging table - and only at the very end copies the data...
--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)

April 1, 2016 at 8:17 pm

#1869279
RE: BCP to insert data from text file to table

PJ_SQL (4/1/2016)
I have this file as below
'A',
'B',
'C',
I am using this bulk insert below:
BULK INSERT test..A FROM 'c:\test.txt'
WITH (
DATAFILETYPE='char',
...
--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)

April 1, 2016 at 8:09 pm

#1869278

Viewing 15 posts - 17,956 through 17,970 (of 59,069 total)