Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,211 through 24,225 (of 59,099 total)

RE: Perform an update but skip lock

laser_steve (3/7/2014)
Thanks all for the replies. I know the system performing the locks is bad, why they couldn't have gone for optimistic locking I'll never know. But I cannot control...
--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)

March 8, 2014 at 11:52 pm

#1695350
RE: avoid self join

mxy (3/8/2014)
max would be two column per employee. its a report they want to view payments and dates of each employee in that format.
I know but, how may employees per...
--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)

March 8, 2014 at 11:31 pm

#1695349
RE: avoid self join

mxy (3/8/2014)
i would like to do display results as below. I can achieve results by self joining back, is there any other way we can achieve
o/p should be
batchidempsalpaiddateempsal1paiddate1
2 ...
--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)

March 8, 2014 at 2:50 pm

#1695330
RE: recursive Stored procedure or function

Eskandari (3/5/2014)
is there any way to have a stored procedure or function like below c# code:
Comment :"i want to convert this c# code to sql server t-sql "
public static IEnumerable<String>...
--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)

March 7, 2014 at 7:39 pm

#1695283
RE: Split a pipe delimited string into two columns

dwain.c (3/6/2014)
There's no reason to call DelimitedSplit8K twice, even if it is super-efficient (bless its heart):
WITH SampleData (s) AS
(
SELECT 'XYZ00001|Test_b|XYZ00002|Test_a|XYZ00003|Test_c'
)
SELECT s
,Col1=MAX(CASE 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)

March 7, 2014 at 5:07 pm

#1695280
RE: Copy from Excel file into SQL table using BCP

tracmonali (3/7/2014)
Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not...
--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)

March 7, 2014 at 5:03 pm

#1695279
RE: SQL Server Work Ethic

I think what Travis is referring to is something that I've recently encountered and it does have quite a bit to do with "work ethic". While it's certainly not...
--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)

March 7, 2014 at 4:55 pm

#1695278
RE: How to add up the monthly total?

MyDoggieJessie (3/7/2014)
To add to SQLCJ's post, you will need to include the ORDER BY date_value at the end to get the OP's expected result - and some ugly string manipulation...
--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)

March 7, 2014 at 4:37 pm

#1695275
RE: Multiple backup at the same time

Jack Corbett (3/7/2014)
I would question why you'd want to run them in parallel if you are writing them all to the same drive, especially if all the databases...
--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)

March 7, 2014 at 4:13 pm

#1695274
RE: Update Query

vijaykumar587 (3/7/2014)
I am sorry for that. Actually there is common column is there in two tables. Please check below
Table1:
PID ID1 ID2 ID3 ID4 ID5 ID6
1 NULL NULL NULL NULL NULL...
--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)

March 7, 2014 at 4:09 pm

#1695273
RE: Capturing the Reason For Change for Type 2 changes

Lempster (3/3/2014)
Jeff Moden (2/28/2014)
Put an index on the "Current-Flag" and watch your GUI's timeout when they try to do an INSERT because of the massive extent splits that will occur....
--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)

March 5, 2014 at 3:17 pm

#1694512
RE: How to shrink log in 2008 r2? URGENT!!!!!!

GilaMonster (3/5/2014)
Jeff Moden (3/4/2014)
Almost forgot. The log file won't shrink past the last VLF currently in use. It is sometimes necessary to first take a backup of 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)

March 5, 2014 at 3:06 pm

#1694507
RE: AS A DBA WHAT I NEED TO CHECK WITH SQL SERVERS MY DAILY,WEEKLY,MONTHLY .

Ed Wagner (3/5/2014)
There are two things that no one mentioned that I believe are critical.
The first thing should be the backups. You should know when they're being taken and...
--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)

March 5, 2014 at 8:33 am

#1694340
RE: Log growing in SIMPLE Recovery Mode

NJDave (3/5/2014)
Thank you for all of the good advice on this thread. I appreciate the time spent.
What you should really be doing, in my humble opinion, is get a hold...
--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)

March 5, 2014 at 8:27 am

#1694334
RE: sql split row into three or more rows

compufreak (3/4/2014)
the problem I have with this is the speed of the query...
any help with increasing the speed??
thanks again to everyone that assisted 🙂
Go back and read Sean's post. ...
--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)

March 5, 2014 at 12:09 am

#1694174

Viewing 15 posts - 24,211 through 24,225 (of 59,099 total)