Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,461 through 32,475 (of 59,099 total)

RE: Help Regarding constraint

pandeesh (9/25/2011)
Hi
I have two columns name and Id in a table
I want to have the design in such a way that it should not allow to insert more than 300...
--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)

September 25, 2011 at 7:03 pm

#1386259
RE: Sql Server Agent producing different results then execution of a sp

Yep... if the privs are the same and the code is the same, there's only one thing left... the data.
Check and make double sure that the job is running against...
--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)

September 25, 2011 at 6:31 pm

#1386256
RE: SQL 2008 - T-SQL query assistance

R.P.Rozema (9/25/2011)
Of course I won't put the employee name in the table, I did get that this is just an example. I just took the table from Joe's example 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)

September 25, 2011 at 5:27 pm

#1386253
RE: the title more sold in Pubs database without using CURSOR

Read up on the subjects that Remi recommended above, try some code on your own, and if you still can't figure it out, post your code and we'll be happy...
--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)

September 25, 2011 at 5:07 pm

#1386251
RE: map file name with table data

scottichrosaviakosmos (9/25/2011)
I have some files in a location and every time when i run my package1 i save the name of files into a table. now when i run my...
--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)

September 25, 2011 at 5:04 pm

#1386250
RE: Selecting all records that occur more than once

CELKO (9/25/2011)
>> I want to select the prospect_nbr and name of all companies in [prospects] table that have the same name and occur more than once. <<
Please be polite enough...
--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)

September 25, 2011 at 4:44 pm

#1386248
RE: Selecting all records that occur more than once

@petervdkerk,
First of all, Joe is absolutely correct... you'll get better answers more quickly if you invest just a minute or two in how you post your data. Please see...
--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)

September 25, 2011 at 4:35 pm

#1386247
RE: Converting rows into columns

Yes, it certainly is possible. Please see the following article for how to do it.
http://www.sqlservercentral.com/articles/T-SQL/63681/
I suspect that you could someday have more than 3 "skills" listed. For how...
--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)

September 25, 2011 at 2:31 pm

#1386241
RE: Scalar Function returns only one char

Gosh, NO!!!! You don't need to make a slow-as-molasses UDF for such a thing. It's just not necessary. Use the following, instead (where "SomeDate" would be 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)

September 25, 2011 at 1:13 pm

#1386238
RE: A time-out occurred while waiting for buffer latch

balasach82 (9/24/2011)
Its Enterprise edition.
Processors: 8
Max Server Memory: set at 10 GB
Memory: 12 GB
In that case, you might want to look into ALTER INDEX instead of DBCC and use the "online"...
--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)

September 25, 2011 at 12:58 pm

#1386236
RE: Query optimizing 2

J Livingston SQL (9/25/2011)
Do you have the code that built the 20M*30*100 data for both tables so we can test at the level you did?
Did you do a comparison of...
--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)

September 25, 2011 at 12:55 pm

#1386235
RE: SQL 2008 - T-SQL query assistance

Dang... I almost forgot...
I call the "Lft" and "Rgt" columns "Bowers" after the two large anchors on the front of large ships. It makes the columns a whole lot...
--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)

September 25, 2011 at 12:26 pm

#1386232
RE: SQL 2008 - T-SQL query assistance

First, I wouldn't store the Employee Name in the table except for demonstration purposes and Joe does cover that in the book I cited. Keep the "functions" of "organization"...
--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)

September 25, 2011 at 12:22 pm

#1386231
RE: pass table name as a parameter in stored procedure

mjbkm (9/25/2011)
Well, I have a huge table. Going on 3,000,000+ records with a aspx web front where users actively query this table with around 10 different parameters. Just...
--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)

September 25, 2011 at 9:14 am

#1386220
RE: MVP Branding

GilaMonster (9/25/2011)
Jeff Moden (9/24/2011)
Part of the reason for that is because of the things they're exposed to after they become an MVP. The information is so cutting-edge that they...
--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)

September 25, 2011 at 8:51 am

#1386215

Viewing 15 posts - 32,461 through 32,475 (of 59,099 total)