Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,291 through 16,305 (of 59,101 total)

RE: use microsoft updates

starttreck2016 (11/19/2016)
There was nothing rude in my original question , and my question was whether the use Microsoft update only lists the updates or does the update itself which 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)

November 19, 2016 at 8:21 pm

#1913586
RE: Wow. Just Wow

This is one of my many fears about putting stuff on the cloud. A lot of people think they have control over their data when, in reality, someone else...
--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 8:17 pm

#1913585
RE: What is Normal?

Oooooo.... don't get me started on the silliness of denormalized data being stored in the database. I'm going through some hell (again) because my predecessors thought it would be...
--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 6:47 pm

#1913584
RE: DTS For Importation of Data From CSV file to SQL SERVER 2008 R2 Express

joshua 15769 (11/17/2016)
I'm not quite sure when and where the data will be 4 or 6 columns since the data source is a scientific device which measures temperatures. It has...
--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 6:14 pm

#1913583
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

Viewing 15 posts - 16,291 through 16,305 (of 59,101 total)