Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,651 through 22,665 (of 59,102 total)

RE: xp_cmdshell / file level permissions

Jason Shadonix (10/11/2014)
I am trying to get the following script to run on a newly created SQL server.
I've set up the xp_cmdshell proxy account to be the same account as...
--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)

October 12, 2014 at 9:40 am

#1751867
RE: The wisdom of developers

sqldriver (10/9/2014)
They insisted something was wrong and that it was always faster. I told them to come back when they found it faster their way.
That's kind of a big...
--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)

October 12, 2014 at 9:19 am

#1751866
RE: trigger

I wouldn't use a trigger for this (especially since you've not used triggers before). A trigger would be "spaghetti code" where you throw something against the wall to see...
--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)

October 12, 2014 at 9:05 am

#1751865
RE: Defrag MASTER and MSDB

I've never defragged either but there's nothing in Books Online under "Restrictions" when you lookup either database that says you can't.
--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)

October 11, 2014 at 10:08 am

#1751807
RE: Update ID in the table

jacksonandrew321 (10/11/2014)
Thanks Eiriksson for ur reply. I wasn't familiar with this id update.
This kind of information is available in a tool called "Books Online". It's the "Help" system for...
--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)

October 11, 2014 at 9:32 am

#1751804
RE: Find greatest value in a series of columns and select a related column value

mcinvalek (10/10/2014)
Table Structure
Camp1_ID, Camp1_Amt, Camp1_PCT, Camp2_Id, Camp2_Amt, Camp2_PCT....,Camp20_ID, Camp_20_Amt, Camp20_Pct
I need to search through the 'Camp_PCT' columns and find the max value, then select the cooresponding Camp_ID. If, 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)

October 10, 2014 at 4:37 pm

#1751762
RE: Improving Index Seek

UDBA (10/10/2014)
I have a query that is performing index seek on a large table and taking about 5 minutes, is it possible to further improve the attached index seek?
Look 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)

October 10, 2014 at 4:24 pm

#1751761
RE: Is html coding is allowed in sql server

jacksonandrew321 (10/10/2014)
Hi Experts
Is this possible to write html codes in the query window of the sql server? I have runned some codes and executed them and they successfully executed but...
--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)

October 10, 2014 at 8:03 am

#1751648
RE: How can i use ouput of PowerShell script in SSRS without upload toSQL DB

nelly.kh (10/8/2014)
I'm new to SSRS 2008 R2. I have been using Report Builder 3.0 to design my reports with no problems .Now, I would like to use as sources output...
--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)

October 9, 2014 at 7:49 am

#1751293
RE: SSRS and DB2 connection

I'm having a similar problem. I hope you're still around so that I can ask, "Did you ever solve this problem" and "How did you do it"?
Thanks.
--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)

October 8, 2014 at 8:35 pm

#1751135
RE: Tools for graphical format

ZZartin (10/8/2014)
Well there's always excel.
... which is neither cheap nor free.
--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)

October 8, 2014 at 11:49 am

#1751069
RE: Difference between ISE vs command line and out of memory

dpoquette (10/8/2014)
After making changes to the code, I'm not having any problems at all. Thanks for the help on the error trapping.
Please post the changes to the code so...
--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)

October 8, 2014 at 11:47 am

#1751068
RE: Book example doesn't work, how come?

GilaMonster (10/7/2014)
The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000 databases any...
--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)

October 7, 2014 at 7:51 pm

#1750813
RE: Performance of the new (2014) Cardinality Estimator

julian.fletcher (10/2/2014)
Has anybody had any experience (good or bad) with this? Microsoft's own documentation (http://msdn.microsoft.com/en-us/library/dn673537.aspx) hints at improvements while warning:
While many workloads will benefit from the new cardinality estimator changes,...
--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)

October 7, 2014 at 7:50 pm

#1750812
RE: Work Pattern Calendar Tables

@itwhiz-2,
Are you all set or do you still need help?
--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)

October 7, 2014 at 5:45 pm

#1750807

Viewing 15 posts - 22,651 through 22,665 (of 59,102 total)