Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,261 through 16,275 (of 59,067 total)

RE: use microsoft updates

starttreck2016 (11/19/2016)
Because your answer was rude, arrogant and overcomplicating and confusing, and this is my post I have the right yo do whatever I like with it. You...
--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 19, 2016 at 5:50 pm

#1913581
RE: Create Job Server

I'll agree that using Maintenance Plans for backups is better than no backups at all but if I had to help a small shop, I wouldn't do that to them....
--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, 2016 at 9:21 pm

#1913559
RE: Questions on filetables

N_Muller (11/18/2016)
Jeff Moden (11/3/2016)
I don't know if you've ever read the following but it might give you some hints about why you might not want to drop the Clustered Index...
--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, 2016 at 3:58 pm

#1913549
RE: Traspose column dynamically Base on ProjectID

Anandkumar-SQL_Developer (11/18/2016)
Dear SSC-Forever ,
Thank you very much. its working well.
You're welcome and thank you for 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 18, 2016 at 6:58 am

#1913416
RE: Strategy to Move incremental data from Migration Server to Target System in migration

getalok_akg (11/15/2016)
Hi Jeff ,
Thanks for reply . Our client is not agree for backup approach due to business constraint . .
Thanks
Alok
It would be really helpful if you told us what...
--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, 2016 at 12:19 am

#1913300
RE: Strategy to Move incremental data from Migration Server to Target System in migration

getalok_akg (11/15/2016)
Hi Jeff ,
Thanks for reply . Our client is not agree for backup approach due to business constraint . .
Thanks
Alok
It would be really helpful if you told us what...
--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, 2016 at 12:16 am

#1913299
RE: Disk space report

kevaburg (11/17/2016)
Jeff Moden (11/16/2016)
kevaburg (11/16/2016)
Hi,
exec xp_fixeddrives;
This returns the amount of free space on your local drives. It is a good place to start....
Regards,
Kev
It's really not. It only shows...
--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, 2016 at 12:09 am

#1913298
RE: Copy/Insert Data to another table with different number of columns

tocy1980 (11/13/2016)
Thank you Jeff.
Really I am still the newbie in SQL so this is still hard for me...
At this moment I am just trying to find for me familiar...
--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, 2016 at 11:43 pm

#1913294
RE: Find the brackets

Stewart "Arturius" Campbell (11/17/2016)
Another cause of disparity are scalar functions, which the execution plan appears to ignore completely.
Agreed. In fact, those little beasties can be downright troublesome to measure...
--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, 2016 at 11:29 pm

#1913292
RE: Traspose column dynamically Base on ProjectID

Anandkumar-SQL_Developer (11/17/2016)
Hi Friends ,
-- Value insertion for table :
select * into ##Test from (
select * from (values (15228683,'20 Houses',100,'Client','Omagh Integrated Primary School','Shellie Butler'),
(15228683,'20 Houses',100,'Client','Omagh Integrated Primary School','Jane Benton'),
(15160840,'Supermarket',100,'Client','OakleeTrinity Housing Association','Shellie...
--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, 2016 at 11:17 pm

#1913291
RE: D3.js & MS SQL datasource

To be honest, I thought "D3" was the latest rage in dietary supplements. I apologize for not being a help but at least this will act as a "bump"...
--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, 2016 at 10:29 pm

#1913284
RE: Get Data between two date ranges

Cawie (11/17/2016)
Hello All,
I am new to SQL coding and I need a help.
I need to select data between two dates and this has to be run as stored procedure. 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)

November 17, 2016 at 10:22 pm

#1913283
RE: audit account

To be brutally honest, if you don't know which permissions to request for this audit, then you're probably not qualified to do the audit.
--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, 2016 at 10:17 pm

#1913282
RE: use microsoft updates

sqlserverDBA2016 (11/17/2016)
If you go to http://www.sqlcoffee.com/sqlserver2014_0005.htm
And go to Microsoft update u wil know what I'm talking about
You read it. It tells you what it does. Do you suppose...
--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, 2016 at 10:14 pm

#1913281
RE: How can automate report from sqlserver to be sent on email everyday.

MMartin1 (11/17/2016)
Jeff Moden (11/16/2016)
tnnelzo (6/20/2013)
Hello!
Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so 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)

November 17, 2016 at 1:46 pm

#1913237

Viewing 15 posts - 16,261 through 16,275 (of 59,067 total)