Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,111 through 25,125 (of 59,099 total)

RE: Return Parent Record value from child records

sturner (12/18/2013)
What you have presented looks like an ugly design. The PK appears to be a string that has a 'EXPXX' suffix appended to it. Then you must apparently strip...
--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)

December 18, 2013 at 12:18 pm

#1674570
RE: Data truncation on MAX column through linked server

spaghettidba (12/17/2013)
Bug filed.
https://connect.microsoft.com/SQLServer/feedback/details/811840/data-truncation-on-varchar-max-column-through-linked-server
Vote up please! 🙂
Voted up. Waiting for the normal response of "Closed - Will not fix". 😉
--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)

December 18, 2013 at 12:09 pm

#1674566
RE: Import many column CSV into 2-column sql table

elliottcoyne (12/17/2013)
Hi Jeff - thanks for the offer of help. I've followed your guide (as far as I was able to) and created the following to mimic my data source:
--truncate...
--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)

December 18, 2013 at 11:54 am

#1674558
RE: BIGINT date format in comparison

SQL Kidu (12/18/2013)
What is the best way to filter out records which has a orderdate column in bigint format ?
The [font="Arial Black"]BEST [/font]way to do this is to attack 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)

December 18, 2013 at 11:36 am

#1674543
RE: Removing the Linked Server 2 hop Limitation

K. Brian Kelley (12/18/2013)
No. xp_cmdshell runs either in the context of the SQL Server service account or the configured proxy account (if access to xp_cmdshell is granted to a non...
--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)

December 18, 2013 at 11:02 am

#1674530
RE: The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

jesuslpm (12/16/2013)
I think this use case is better managed using client side dynamic sql generation. I'm not talking about concatenating strings to build the sql statement. I'm refering to using...
--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)

December 18, 2013 at 7:59 am

#1674441
RE: Select is Slow

LutzM (12/18/2013)
To me it sounds like a combination of paging and catch-all-queries.
Therefore, a combination of Gails catch-all article[/url] together with Pauls Optimising Server-Side Paging[/url] should get you startet.
Agreed. 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)

December 18, 2013 at 7:10 am

#1674414
RE: Select is Slow

ChrisM@Work (12/16/2013)
yuvipoy (12/15/2013)
here i meant scroll is where condition..... for every scroll i will be giving 1000 records...
For the 1st time i will return 1000 records and next time 1001...
--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)

December 17, 2013 at 10:53 pm

#1674277
RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

yuvipoy (12/17/2013)
Ok... so where is that information stored and is it stored for every row so you can do variable length columns?
The information will be stored in a BLOB table...
--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)

December 17, 2013 at 10:49 pm

#1674276
RE: Fusion-IO or Nimble?

Thanks folks. From the sounds of it, both products are great but have slightly different applications. I'll pass this on to the boys in NetOPs. I 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)

December 17, 2013 at 10:16 pm

#1674274
RE: Help with updating records in a column.

Luis Cazares (12/17/2013)
As far as I understand, it should be more like this to keep the "prod" at the end of the name.
UPDATE TA
SET ServerName...
--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)

December 17, 2013 at 10:12 pm

#1674273
RE: Are the posted questions getting worse?

mister.magoo (12/17/2013)
Good day Threadizens 🙂
I have written an article (my first) on how to get help with SSRS reports.
It was inspired by Jeff's classic "Forum Etiquette: How to post data/code...
--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)

December 17, 2013 at 10:06 pm

#1674272
RE: SQL trigger

wat3575 (11/22/2013)
We are using a CRM system and I have had trouble creating a trigger that would automatically update another field on a record. The first table I am working...
--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)

December 17, 2013 at 2:04 pm

#1674230
RE: Help with updating records in a column.

anushakadiyala 52521 (12/17/2013)
Thank you for taking a look, This is the code I have been trying.
UPDATE TA
SET ServerName= REPLACE(ServerName, '%.%.dim.com', '')
WHERE Servername like '%.%.dim.com%'
You cannot use wildcards in a REPLACE.
basically...
--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)

December 17, 2013 at 1:49 pm

#1674224
RE: Extract the data based on the present quarter and last quarter

Smash125 (12/16/2013)
How to
Extract the data based on the present quarter and last quarter in SQL
Please let me know
Regards,
Praveen
SELECT TheData
FROM dbo.SomeTable
WHERE SomeDateColumn >= DATEADD(qq,DATEDIFF(qq,0,GETDATE())-1,0)
;
--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)

December 17, 2013 at 1:36 pm

#1674221

Viewing 15 posts - 25,111 through 25,125 (of 59,099 total)