Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,276 through 37,290 (of 59,072 total)

RE: View performance

Dave Hoogendoorn (8/15/2010)
Hi There,
Changing the query to explicit INNER JOINs with ON statements might prevent improper execution plan.
In your current query, their might be a possibility that SQL first joins...
--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)

August 15, 2010 at 9:25 pm

#1207137
RE: Sql Query to extract the data.. Need Help...

Rajiv Kumar (8/14/2010)
I have table name employee with following fields -
EmpID Name ManagerID
against each employee, manager id is avaiable and a manager is also an employee...
i need a sql...
--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)

August 15, 2010 at 9:22 pm

#1207136
RE: Sql Query to extract the data.. Need Help...

Rajiv Kumar (8/14/2010)
I have table name employee with following fields -
EmpID Name ManagerID
against each employee, manager id is avaiable and a manager is also an employee...
i need a sql...
--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)

August 15, 2010 at 9:20 pm

#1207135
RE: How to do Dynamic counts!

To answer your question, "Yes".
To solve your problem, please see the following. Post back if you have questions but try the code first... you can do some amazing stuff...
--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)

August 15, 2010 at 9:06 pm

#1207134
RE: 20,000 logins in five minutes !?

robertfolkerts (7/22/2010)
I have started working as a DBA with SQL Server 2008 in a small company. We have a lightly/moderately loaded database running SQL Server 2008. During normal...
--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)

August 15, 2010 at 9:02 pm

#1207133
RE: Parsing Parameters in a Stored Procedure

dbuendiab (8/15/2010)
SQLZ (8/13/2010)
This was an interesting article with an even more interesting discussion.
The thing I'd like to pick up on, that drew my attention, was your reasons for moving away...
--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)

August 15, 2010 at 11:55 am

#1207093
RE: MCJ - The Missing Link

Steve Jones - Editor (7/15/2010)
Just wondering if this has fallen off everyone's radar?
http://sqlservercentral.sharepointspace.com/
Heh... oh my! Another month has gone by and nothing has happened on the SharePoint site since...
--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)

August 14, 2010 at 11:49 pm

#1207073
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Heh... Well said, Tom. I LOVE "evil concepts" especially in T-SQL. 😛
--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)

August 14, 2010 at 1:23 pm

#1207055
RE: Are the posted questions getting worse?

Paul White NZ (8/14/2010)
Jeff Moden (8/13/2010)
Paul White NZ (8/12/2010)
What sort of hint did you have in mind? Index hints don't work with table variables, and you can't give 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)

August 14, 2010 at 1:01 pm

#1207051
RE: generate insert statements with data

WayneS (8/9/2010)
Jeff Moden (8/8/2010)
drew.allen (8/7/2010)
Here's an example using the Information_Schema.Tables view. WARNING: XML is case sensitive
Thanks, Drew. Rumor has it that it's also pretty touchy about special characters...
--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)

August 14, 2010 at 12:36 pm

#1207049
RE: Keeping Fresh

WayneS (8/6/2010)
CirquedeSQLeil (8/6/2010)
I think project rotation or task rotation maybe even responsibility rotation is a good way to keep fresh in the business. It helps to be able 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)

August 14, 2010 at 12:29 pm

#1207047
RE: SQL subquery WHERE IN clauses

David Burrows (8/10/2010)
but this is ...
poor design
poor query
poor performance
as will be shown when Jeff catigates me for even dare to post this 😀
Heh... only for the spelling 😛 because, 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)

August 14, 2010 at 12:23 pm

#1207046
RE: The Multi-valued Parameters problem in Reporting Services

Ah... sorry, my apologies. I thought I'd posted the 8k splitter code on this thread before. Guess not. So, here it is. It's mostly comments 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)

August 14, 2010 at 12:09 pm

#1207045
RE: The Multi-valued Parameters problem in Reporting Services

Ok... here we go with a test for Alex's function. I was right about the CTE still being "Hidden RBAR" even though it uses all variables and is an...
--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)

August 14, 2010 at 12:00 pm

#1207044
RE: The Multi-valued Parameters problem in Reporting Services

Alex Grinberg-230981 (8/13/2010)
INSTALL function (code below) and use it to split a value
CREATE FUNCTION [dbo].[StringToTable]
(@RawString nvarchar(4000), @Delimiter nvarchar(10) )
RETURNS
@VList 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)

August 14, 2010 at 11:23 am

#1207043

Viewing 15 posts - 37,276 through 37,290 (of 59,072 total)