Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,831 through 19,845 (of 59,098 total)

RE: Machine needs for developing and running sql

Ben Whyall (8/20/2015)
Hi
I'm not sure this is the best forum but i'm hoping its the best fit.
I am a developer mostly working on .net applications with a SQL...
--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)

August 20, 2015 at 10:40 am

#1821479
RE: How to Recover Database without Backup

crickwilli (8/20/2015)
Get more effective safe and secure software, you can download third-party software, Kernel for SQL Database Recovery Tool. This software easy to recover complete database objects available in .MDF...
--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)

August 20, 2015 at 8:37 am

#1821430
RE: PDF iFilter problems (again!)..

Jeff ingham (3/12/2014)
...hopefully this might save someone from premature hair loss!
Apparently, it DID! Well done!
--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)

August 20, 2015 at 8:27 am

#1821424
RE: Multiple records on one row..

ByronOne (8/20/2015)
Cheers Chris
I'll give this a whirl.
Thanks for the really speedy response!
BO
The question now is, do you understand how and why it works?
I ask because Chris' 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)

August 20, 2015 at 8:07 am

#1821410
RE: SQL Turn Row data to Column

Eirikur's CROSSTAB solution is an effective solution for when the maximum number of items is 3 and can be easily converted for larger known maximums. It's also easily converted...
--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)

August 20, 2015 at 8:04 am

#1821408
RE: SQL Turn Row data to Column

Jayanth_Kurup (8/20/2015)
@jeff Looks like a perfect example on using dynamixc SQL 🙂
Nah. Not for this. It's a simple CROSSTAB or PIVOT problem, especially since it's known that there...
--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)

August 20, 2015 at 8:01 am

#1821404
RE: BCP Command with headers

vikramchander90 (8/20/2015)
Hi,
I have a table which has few columns as Numeric value. I need to export the ouptut into a csv file as a report with column headers. 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)

August 20, 2015 at 7:41 am

#1821390
RE: Find working time of each employee

Really, really looks like and sounds like homework. Even if it's not, you should at least try. And rules 4, 5, and 6 create an oxymoron because 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)

August 20, 2015 at 12:14 am

#1821263
RE: The Road to Success

One of my previous bosses said that "If you don't make mistakes, I'm not pushing you hard enough".
While I agree with that, the place to experiment and make mistakes 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)

August 19, 2015 at 11:59 pm

#1821262
RE: Where IN @txtVariable (where txtVariable is a CSV list)

Kevlarmpowered (8/19/2015)
My DBAs frown on dynamic SQL...
They REALLY need to get over that. Properly written dynamic SQL is SQL Injection proof, safe, fast, and will cache an execution...
--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)

August 19, 2015 at 11:52 pm

#1821260
RE: Hiding the security folder from contractors using SMSS

hurricaneDBA (8/19/2015)
Dear Everyone
I am setting up a database for one contractor who needs to access one of our databases but i need to remove the permission for them to view...
--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)

August 19, 2015 at 11:51 pm

#1821259
RE: Converting a column of type nvarchar to datetime

aldous.chris (8/19/2015)
Hi All,
Thanks for your help and quick responses. There were values which weren't allowed in the column!
All columns have been successfully updated!
Cheers,
Chris
There are very few places 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)

August 19, 2015 at 9:10 pm

#1821245
RE: Update Statistics & Rebuild index (MaintenancePlan)

One of the more recognized solutions for index maintenance can be found at the following link.
https://ola.hallengren.com/
--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)

August 19, 2015 at 9:06 pm

#1821242
RE: Update Statistics & Rebuild index (MaintenancePlan)

lgluna20 (8/19/2015)
Hello
I hope you are fine.
I have a questions about Update Statistics & Rebuild index.
Every day I have a maintenance Job of my DBs where I Include Update Statistics...
--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)

August 19, 2015 at 9:04 pm

#1821241
RE: SQL Turn Row data to Column

Dee Dee-422077 (8/19/2015)
Hi,
ItemID ItemName Price
1 Test 1 100
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)

August 19, 2015 at 8:59 pm

#1821239

Viewing 15 posts - 19,831 through 19,845 (of 59,098 total)