Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,436 through 33,450 (of 59,099 total)

RE: Are the posted questions getting worse?

Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last...
--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)

June 28, 2011 at 6:20 pm

#1345594
RE: After successful table insert no rows showing in SELECT output or SP_SPACEUSED output

ganci.mark (6/28/2011)
Update:
Late yesterday the developer reported this occuring again so I investigated.
By this time I was convinced it had to be something they were doing.
I inserted a test record 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)

June 28, 2011 at 6:15 pm

#1345593
RE: Quick question on zip code searches: U.S. and Canada

Absolutely outstanding, Matt! I didn't even think to ask you if you had matched datatypes because I included it all in the code example. VERY happy you sussed...
--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)

June 28, 2011 at 5:51 pm

#1345587
RE: how to create surrogate id for view in tsql

maheshkrishnas (6/27/2011)
hi, this is my source table i need to create view table for this with surrogate key.Can u help me................
SELECT TOP 1000 [C_ID]
,[C_NM]
...
--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)

June 27, 2011 at 11:14 pm

#1344954
RE: can we create surrogate id on view table

Duplicate post. No replies here, please. Please see:
http://www.sqlservercentral.com/Forums/Topic1132030-392-1.aspx
--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)

June 27, 2011 at 11:14 pm

#1344953
RE: After successful table insert no rows showing in SELECT output or SP_SPACEUSED output

ganci.mark (6/24/2011)
Something strange ?I ran into today.
After inserting rows into a table and receiving no errors and xx row(s) inserted messages,
Selecting from the table yielded no rows. Select count(*) resulted...
--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)

June 27, 2011 at 10:47 pm

#1344949
RE: How to select all the tables

opc.three (6/27/2011)
stormsentinelcammy (6/27/2011)
Please post how to select the tables belonging to a certain schema 🙂
Please start a new thread 🙂 The OP wanted to know if it was possible, not...
--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)

June 27, 2011 at 10:34 pm

#1344947
RE: Combining Multiple Records Into One

opc.three (6/27/2011)
You can use SQLCLR aggregate GROUP_CONCAT to do this (get it here http://groupconcat.codeplex.com):
SELECT jc.OrderNum,
dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries
FROM ...
--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)

June 27, 2011 at 10:24 pm

#1344943
RE: PRECAUTIONS TO BE TAKEN FOR DATABASE BEFORE REBUILDING INDEX

aatishpatel (6/27/2011)
I would change the database recovery to simple or bulk logged.
[font="Arial Black"]WHY???[/font]
--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)

June 27, 2011 at 10:12 pm

#1344941
RE: Help with another developer's T-Sql asp.net code

Based on the little bit of info you've given us, this sounds like either an intermittent network or file system error.
--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)

June 27, 2011 at 9:46 pm

#1344939
RE: Alternate options of SQL Profiler

Depending on what you're looking for, you can right-click a server is SSMS and then select "Reports". There you will find a large number of reports and some 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)

June 27, 2011 at 9:43 pm

#1344938
RE: Code Ownership - DBA vs. Developer

Gosh... good questions, Craig.
If we can, in fact, put aside the idea that Developers frequently have no readability on a production database or server, here's my "It Depends" answer. 😉
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)

June 27, 2011 at 9:23 pm

#1344937
RE: Quick question on zip code searches: U.S. and Canada

matt6749 (6/27/2011)
Notes:
a) i think it would be even quicker if I didn't join with my existing Providers and Occupations table
I notice you do column sorts based on that information. ...
--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)

June 27, 2011 at 8:29 pm

#1344936
RE: Quick question on zip code searches: U.S. and Canada

matt6749 (6/27/2011)
...for some reason searching on Canadian zip codes takes longer, even though U.S. and Canadian zip codes are in same table.
It's because the 2nd triad of characters in 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)

June 27, 2011 at 8:10 pm

#1344934
RE: Where Do You Go for Authoritative SQL Server Best Practices?

Jason Selburg (6/27/2011)
I just ask Jeff. 😀
:-P:blush:
Thanks, Jason.
--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)

June 27, 2011 at 6:55 pm

#1344921

Viewing 15 posts - 33,436 through 33,450 (of 59,099 total)