Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,301 through 30,315 (of 59,101 total)

RE: Are the posted questions getting worse?

Lynn Pettis (4/23/2012)
I will admit that I do get frustrated with some posters. A couple tonight got to me just with their initial post, hence the lmgtfy response. ...
--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)

April 23, 2012 at 10:51 am

#1477645
RE: pivot against two different columns

polkadot (4/22/2012)
What was important for me here was that I get the problem solved within pivot framework
Why? Pivot is usually slower and a whole lot more ugly for more...
--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)

April 23, 2012 at 10:32 am

#1477633
RE: Autgrouth value for user and tempDB Databases

george sibbald (4/23/2012)
This is probably the link Jeff is thinking of.
Check the URLs it links to as well.
With logs the important thing to be aware of the size and number...
--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)

April 23, 2012 at 10:28 am

#1477628
RE: Autgrouth value for user and tempDB Databases

Robin Sasson (4/23/2012)
That's really interesting Jeff. Years ago I went on a MCP course for SQL 2000. The instructor recommended 50% (!!!!) growth as a blanket strategy.
His reasoning was...
--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)

April 23, 2012 at 10:25 am

#1477627
RE: Best way to select a large amount of data?

ricardo_chicas (4/23/2012)
Hello all
actually all I did was to reate a loop that read the data 10000 records at the time, that allow me to use one of the main indexes...
--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)

April 23, 2012 at 10:20 am

#1477624
RE: URGENT PLEASE Got a SQL Scenario to solve

Heh... even when I went back to read what you and Mark had said, there's (IMHO) some abiguity and I didn't want to just assume. Thanks for the answer.
--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)

April 23, 2012 at 10:17 am

#1477622
RE: please give me a solution for this request

capn.hector (4/23/2012)
+1 however i saw this same question as homework for one of my sql classes.
Interesting! Where did you take such a class? I ask...
--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)

April 23, 2012 at 10:12 am

#1477619
RE: Can you restore a 2008 DB to 2005?

rummings (3/13/2012)
I was given a SQL Server 2008 "bak" file.... it would not restore to SQL Server 2005. I then tried to restore to SQL Server 2008 to see if...
--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)

April 23, 2012 at 8:27 am

#1477530
RE: Can you restore a 2008 DB to 2005?

Robin Sasson (4/23/2012)
Then generate separate scripts for the data.
BWAAA-HAAAA! That's a bit like saying "It's easy to get to the moon. Just build a rocket ship." 😛
--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)

April 23, 2012 at 8:26 am

#1477528
RE: Autgrouth value for user and tempDB Databases

And be very aware that growth by percentage is almost never OK. If your db is small and growing, it can fragment the hell out of the database, 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)

April 23, 2012 at 8:21 am

#1477523
RE: HIERARCHYID, Select data in topological order but also order by name within direct subordinates

Almost forgot. Here's an article that explains one method to do as you ask.
http://www.sqlservercentral.com/articles/T-SQL/72503/
--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)

April 23, 2012 at 12:23 am

#1477303
RE: a very COMPLEX aggregation query

dwain.c (4/22/2012)
I have to ask... does "RESOLVED" and "CLOSED" actually mean the same thing? Legally speaking, I would think not.
--Jeff Moden
When I saw you had posted to 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)

April 23, 2012 at 12:18 am

#1477301
RE: Are the posted questions getting worse?

Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Revenant (4/22/2012)
Lynn Pettis (4/22/2012)
Sometimes I wonder if some people posting questions even try to solve their own problems. Doesn't help when they start mixing...
--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)

April 23, 2012 at 12:14 am

#1477298
RE: please give me a solution for this request

anil.janu143 (4/22/2012)
//this is my table
create table std_table
(
id int,
name nvarchar,
address nvarchar,
)
//this is my table data
10 null null
null anilkuar null
null null hyderabad
//i want the data like this
10 anilkumar hyderbad
Given nothing else...
--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)

April 23, 2012 at 12:02 am

#1477293
RE: HIERARCHYID, Select data in topological order but also order by name within direct subordinates

WRACK (4/22/2012)
Jeff Moden (4/22/2012)
Let it be known right up front that I don't use the HierarchyID datatype because I prefer other methods. That, notwithstanding, the way to do 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)

April 22, 2012 at 11:56 pm

#1477287

Viewing 15 posts - 30,301 through 30,315 (of 59,101 total)