Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,486 through 22,500 (of 59,072 total)

RE: Trying to Execute a SQL Agent Job With Powershell in Job Steps

Polymorphist (11/11/2014)
Hello -
I'm really stuck on this issue i'm having today. Here's my set-up:
1) I created a SQL Agent job which calls an .exe file to connect 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)

November 12, 2014 at 12:51 pm

#1758076
RE: Possible locking problem with Sysadmin login?

Jake Shelton (11/12/2014)
Hi all,
We have an 3rd party backup software that requires Sysadmin rights (I know - I don't like it but that's what they bought, grrr!), however when 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 12, 2014 at 12:49 pm

#1758075
RE: Get Domain

If the email address are, indeed, prevalidated, then there's no need for a triple reverse nor any use of DelimitedSplit8K, which actually returns too much information in this case. ...
--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 12, 2014 at 12:41 pm

#1758073
RE: updating a 25 million records in batches

klineandking (11/11/2014)
i have asked the question,assume both tables are a heap,how would you update the table in batches of 5000
Unless there's an index on the EncryptionID of both tables, 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 11, 2014 at 8:46 am

#1757706
RE: Cross Tab/Pivot

Never mind. I believe the following does what you ask. You'll need to change the table name in the FROM clause to whatever your tablename actually 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)

November 10, 2014 at 8:34 pm

#1757600
RE: Cross Tab/Pivot

tamer.h (11/10/2014)
Good Day for everybody,
here is a table shows the dates and times of entry and exit of staff throughout the day, where each record shows that either employee's entry...
--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 10, 2014 at 5:37 pm

#1757598
RE: variable char

What this whole thing looks like is the possibility of SQL Injection. It also looks like a "Catch All" query and the proper way to do it can 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 10, 2014 at 5:13 pm

#1757597
RE: Query becoming slower when records are retrieved..how to make it faster

Caching is a good idea but with only 10,000 rows, this should be sub-second. The correct indexes will make that happen.
Shifting gears a bit, if you really...
--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 10, 2014 at 3:56 pm

#1757574
RE: Report ignores WHERE clause in SPROC

thottle (11/10/2014)
Are you absolutely sure that something other than WidgetA and WidgetB have data for the last 7 days?
Yes. If it doesn't, dataset 2 tossed up a blank report,...
--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 10, 2014 at 3:04 pm

#1757568
RE: hi...this is chandra

chandrachamarthi8 (11/10/2014)
it display the schema on the result
Look carefully. Are you sure that it shouldn't be spelled "customer" instead of "coustmer"?
--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 10, 2014 at 2:59 pm

#1757567
RE: Report ignores WHERE clause in SPROC

thottle (11/10/2014)
I've got a strange one in SQL Svr 2008R2.
I wrote a report that pulls datasets from two different SPROCs.
Dataset 1 has the following code (sanitized to protect 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 10, 2014 at 2:43 pm

#1757565
RE: Updating Tables

mhildebrand (11/10/2014)
Steve, apologies about my terminology - still learning and realizing it makes a huge difference. I think you hit the crux. i just don't think there 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)

November 10, 2014 at 2:37 pm

#1757561
RE: Query becoming slower when records are retrieved..how to make it faster

Do you have the correct indexes on the table to support the hierarical lookups caused by the recurssion of the CTE? Also, who is going to read 10,000 rows?
--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 10, 2014 at 9:34 am

#1757466
RE: How to catch even and odd weeks?

If it's supposed to be based on ISO week number, substitute the ISOWEEK datepart in Sean's good code above.
--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 10, 2014 at 7:40 am

#1757430
RE: Log Backup size bigger than Full Backup

haichells (11/10/2014)
Hi,
I have a 2008 database where I take Full backup on Saturday and Log backup (once in a day) for rest of the days. Here my log backup files...
--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 10, 2014 at 7:34 am

#1757429

Viewing 15 posts - 22,486 through 22,500 (of 59,072 total)