Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,581 through 20,595 (of 59,072 total)

RE: Are the posted questions getting worse?

TomThomson (5/23/2015)
LinksUp (5/23/2015)
When I see that Joe Celko has posted a message I know that some level of entertainment will be attained:rolleyes:. I guess he crossed some boundary. It seems...
--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)

May 25, 2015 at 12:55 pm

#1800433
RE: to find equal and opposite rows in a table

yb751 (5/25/2015)
Could you further explain why C is eliminated from your desired output? In fact we could use a little more info in general. Without knowing how A...
--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)

May 25, 2015 at 12:23 pm

#1800432
RE: how temp tables are assocated to deffred recompilation.

I agree with Gail. What problem are you actually having? Is there some sort of a performance problem that you're trying to 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)

May 25, 2015 at 12:18 pm

#1800431
RE: Tuning expensive query

The question that I also have is where are you returning this information to because no one will have the time to read even a thousand 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)

May 25, 2015 at 12:16 pm

#1800430
RE: Scale out SQL Server Databases

simon.harvey 41170 (5/25/2015)
I didn't necessarily buy all of it but I did see an MS product manager give a fairly decent presentation on how Azure could be used in a...
--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)

May 25, 2015 at 12:11 pm

#1800429
RE: Compare this years data with last years data - day adjusted

Use ISOWEEK for this.
--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)

May 25, 2015 at 12:03 pm

#1800428
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Inn the meantime, can you post your test data generator that you're using? You said the Eirikur got beat up by a flaw in SQL Server so I'd like...
--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)

May 25, 2015 at 12:02 pm

#1800427
RE: Advanced ranking function

Luis Cazares (5/25/2015)
This might be simpler to understand.
WITH CTE AS(
SELECT *, (ROW_NUMBER() OVER(PARTITION BY Country ORDER BY Id)+ 2) / 3 AS rowrank
...
--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)

May 25, 2015 at 11:34 am

#1800422
RE: Script table and data

river1 (5/25/2015)
Hi,
I have a table with data.
I want to create the table and its data on other place. What is the quick way of doing this script?
Thank you
In relation 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)

May 25, 2015 at 11:22 am

#1800421
RE: SQL Replace function - without hardcoding

Minnu (5/25/2015)
Hi Team,
using below query to raplace the string values (REPLACE abc with T1223), how to use the query without hard coding.
i want to store the values in another temp...
--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)

May 25, 2015 at 11:17 am

#1800419
RE: Alter query to avoid hardcoding

Minnu (5/25/2015)
Hi Team,
using below query to raplace the string values (REPLACE abc with T1223), how to use the query without hard coding.
i want to store the values in another temp...
--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)

May 25, 2015 at 11:16 am

#1800418
RE: SQL Cursor Logic

Minnu (5/25/2015)
Hi Team,
Using below table.
UserStrg_1Strg_2
--------------------------------
MiamiTestTest_1
MiamiTest_1Test_2
MiamiTest_2Test_3
MiamiTest_3Test_4
MiamiTest_4Test_5
to replace the strg_1 value with Strg_2 value using below cursor, but the cursor is iterating 5 times and the select query in below cursor 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)

May 25, 2015 at 11:13 am

#1800417
RE: Disable and Enable trigger

Shifting gears, triggers are normally put in place to guarantee that something occurs when the data is INSERTed, UPDATEd, or DELETEd. Why do you need to overcome the trigger...
--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)

May 25, 2015 at 10:59 am

#1800415
RE: Memorial Day 2015

william-700725 (5/25/2015)
Steve,
"Happy Memorial Day"?
Reflective, yes, certainly. Somber, perhaps. Happy? Not really -- it's not supposed to be that kind of a holiday.
Reflecting on all those that have been lost, I'm...
--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)

May 25, 2015 at 10:12 am

#1800403
RE: Usages for Powershell

I use PowerShell in a manner similar to what Shawn posted and probably don't even need it for that but it was convenient because someone posed a loop example that...
--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)

May 25, 2015 at 10:02 am

#1800402

Viewing 15 posts - 20,581 through 20,595 (of 59,072 total)