Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,156 through 19,170 (of 59,098 total)

RE: Good Basic T-SQL Exercises

Steve Jones - SSC Editor (11/18/2015)
Thanks, everyone. Trying to get some learning material for people together.
I have to ask... what is this all for? Where will this learning take...
--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)

November 18, 2015 at 6:01 pm

#1840869
RE: SQL Injection - The Revenge

Terje Hermanseter (11/18/2015)
Naming absolutely no names, have you ever run into resistance in implementing what you know to be vital security features?
Unfortunately, more or less every single day/week at...
--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)

November 18, 2015 at 11:50 am

#1840803
RE: SQL Injection - The Revenge

PHYData DBA (11/2/2015)
Can you point me to the Compliance regulation that demands SSN be encrypted?
I've not had to cough up the links in a very long time and the ones...
--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)

November 18, 2015 at 11:49 am

#1840802
RE: A Case FOR Cursors...

No. Like any other software, you find out what went wrong and fix 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)

November 18, 2015 at 10:21 am

#1840777
RE: 150 GB Backup (compressed) taking over 1 day

cphite (11/18/2015)
jbrandenburg (11/17/2015)
I have been working very closely with the storage admin. He has confirmed things appear to be setup properly. The SQL server and the backup 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)

November 18, 2015 at 10:17 am

#1840776
RE: Unable to print the charindex of a special character of its 4th occurrence.

SQL-DBA-01 (11/18/2015)
I wanted to generate databases with auto seq no.
Ah. Thank you and understood. Before you continue down that path, though, consider how many swear words you might...
--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)

November 18, 2015 at 10:07 am

#1840773
RE: Unable to print the charindex of a special character of its 4th occurrence.

SQL-DBA-01 (11/17/2015)
What's wrong in this query?
SELECT CHARINDEX('_', name) FirstIndexOf,
--CHARINDEX('_', name)+1,
CHARINDEX('_', name, (CHARINDEX('_', name)+1)) SecondIndexOf,
charindex('_',name, CHARINDEX('_',name,(charindex('_',name ) + 1 )) + 1 ) ThirdIndexOf,
charindex('_',name,CHARINDEX('_',name,(charindex('_', name ,(charindex('_',name ) + 1 )) +...
--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)

November 18, 2015 at 8:38 am

#1840713
RE: upload and store TIF (Image) files into a SQL Server Database

Andy Warren (11/17/2015)
Jeff, I've always been a fan of storing them in the db, but it's never one size fits all. The system I support now has 200+ TB -...
--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)

November 18, 2015 at 8:35 am

#1840708
RE: A Case FOR Cursors...

patrickmcginnis59 10839 (11/18/2015)
Jeff Moden (11/17/2015)
Hugo Kornelis (11/17/2015)
I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed cursor solution,...
--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)

November 18, 2015 at 8:01 am

#1840681
RE: A Case FOR Cursors...

Hugo Kornelis (11/18/2015)
Allow me to shakup your memory. When you first posted quirky update, you had included a good handful of conditions in the article, and swore that those conditions...
--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)

November 18, 2015 at 6:58 am

#1840651
RE: Good Basic T-SQL Exercises

Steve Jones - SSC Editor (11/17/2015)
Jeff Moden (11/16/2015)
On #1... is that a trick question? If you have a PK, you shouldn't have duplicates, right? Can you provide more...
--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)

November 17, 2015 at 8:26 pm

#1840520
RE: running sql profiler

GilaMonster (11/4/2015)
Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?
Depending on where you run it from and how you run it
Profiler can fill up the...
--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)

November 17, 2015 at 8:11 pm

#1840519
RE: Best practices - Linked server naming convention

sqld-_-ba (11/6/2015)
- developers should not have to modify code when deploying between environments DEV->TEST->PROD. This rules out using actual server name as linked-name.
- the name should easily identify actual 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)

November 17, 2015 at 7:58 pm

#1840518
RE: Index Build Space Calculation

p.s. Allocating another 50-100GB to the app is going to be a whole lot cheaper than you having to mess around all the time whenever you defragment the tables.
--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)

November 17, 2015 at 7:52 pm

#1840517
RE: Index Build Space Calculation

have2much (11/9/2015)
If possible
- switch recovery model of the database to simple before starting rebuild and switch to full once done ?
- Partitioning may also help where you do have...
--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)

November 17, 2015 at 7:47 pm

#1840516

Viewing 15 posts - 19,156 through 19,170 (of 59,098 total)