Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,216 through 25,230 (of 59,099 total)

RE: Relationally Divided over EAV

Outstanding article, Tony. Well done. All too often, people will avoid the use of a tool highly appropriate for a given task just because someone says it's 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)

December 8, 2013 at 2:58 pm

#1671777
RE: Partitioned Views

Sorry for the interuption but I have to make sure that people understand a couple of things...
I'd like to warn everyone that reads this article or any other article on...
--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)

December 8, 2013 at 1:17 pm

#1671771
RE: SQLServerCentral apologizes and you can win a book

Getting back to the subject of this thread... the corrective actions taken on this incident by the proprietors of SQLServerCentral and it's wonderful Editor-in-Chief, Mr. Steve Jones, are part 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)

December 8, 2013 at 9:53 am

#1671759
RE: SQLServerCentral apologizes and you can win a book

Malcolm Wynden (12/7/2013)
-- Create sample data
-- Each Poster gets their name (I'm pretending their name is unique),
-- a posting ID, a flag to confirm their post...
--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)

December 8, 2013 at 9:39 am

#1671758
RE: display order by like 1,2,3,4,5...............plz write quarie

shashianireddy (12/7/2013)
IT SHOWS ERROR
Conversion failed when converting the varchar value '1867 C' to data type int
There's been a lot of code and suggestions on this thread. Please post...
--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)

December 7, 2013 at 8:40 am

#1671722
RE: Is this good practice for using a view?

raysteve43 (12/3/2013)
We have a large lookup table with 200k records. This table is used frequently in a high volume database. We now have to update 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)

December 6, 2013 at 5:53 pm

#1671695
RE: Check to see if multiple VALUES exsit in a table

Minnesota - Viking (12/6/2013)
Thank you sir. I should start using temp tables. I was able to achive what I wanted.
The "Temp tables" you're speaking of was actually a 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)

December 6, 2013 at 5:42 pm

#1671694
RE: SQLServerCentral apologizes and you can win a book

smutallib (12/4/2013)
-- The following script will generate time between given start time and end time
-- Row_number() window function at the end is used to generate serial no.
DECLARE @T_AVAILABLE_TIME...
--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)

December 5, 2013 at 3:30 pm

#1671335
RE: SQLServerCentral apologizes and you can win a book

jim-1022345 (12/4/2013)
Window Functions are a great addition to TSQL. I use them all the time now.
WITH RandomData AS
(
SELECT 1 AS Number
UNION ALL
SELECT Number + 1
FROM RandomData
WHERE Number < 200
)
SELECT
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)

December 5, 2013 at 3:27 pm

#1671334
RE: Are the posted questions getting worse?

GilaMonster (12/4/2013)
In unrelated news, slightly belated drum rolls please..
Absolutely awesome!
--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)

December 5, 2013 at 8:44 am

#1671159
RE: server automatic restart

sqlfriends (12/4/2013)
Thanks,
So for the first top 2 records, can we see it is a hardware problem or not?
I don't know the answer to that question. I'm thinking 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)

December 4, 2013 at 4:19 pm

#1670889
RE: insert into table execution of a stored procedure

bkshn (11/30/2013)
Yes they are same
As I asked before, have you checked the compatability level of the database?
--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)

December 4, 2013 at 4:13 pm

#1670887
RE: insert into table execution of a stored procedure

The problem with using OPENROWSET is that it requires "SA" privs. That's ok for jobs but should not be ok for application logins.
--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)

December 4, 2013 at 4:12 pm

#1670886
RE: Fusion-IO or Nimble?

alexandar_narayan (12/4/2013)
I think this thread is just about answered but I wanted to add that I think a lot of the things in SQL 2014 are going to be really...
--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)

December 4, 2013 at 4:10 pm

#1670885
RE: Cannot restore database. Cannot get exclusive accesss

sqlsurfing (12/4/2013)
I do a lot of restores in my Dev and QA environments. They both have a wealth of little connection greedy web services running against them so I...
--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)

December 4, 2013 at 4:06 pm

#1670884

Viewing 15 posts - 25,216 through 25,230 (of 59,099 total)