Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,666 through 37,680 (of 59,072 total)

RE: Page split with Clustered index

RakeshRSingh (7/13/2010)
I am testing Page Split with Clustered Index and Non-clustered Index.
I have created Single Clustered Index on a table and Inserted incremental values in the table. I do have...
--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)

July 14, 2010 at 1:10 am

#1192592
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

gserdijn (7/14/2010)
Dutch Anti-RBAR League
I've just gotta love a signature line like 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)

July 14, 2010 at 1:06 am

#1192589
RE: Select a minimum number of rows

john-902052 (7/13/2010)
I would love to understand your code.
The code makes use of an on-the-fly "Tally" Table and it's a powerful tool/skill to have under your belt. Take a look...
--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)

July 14, 2010 at 12:33 am

#1192574
RE: Character type number convert

Heh.... I've really got to learn to read the other posts before posting. :blush:
--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)

July 14, 2010 at 12:28 am

#1192573
RE: The Private Cloud

I can't wait for the folks from one the companies that I worked at, that continue struggling with Month End performance, to try such a thing so that we can...
--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)

July 14, 2010 at 12:22 am

#1192570
RE: Between Statment only for current day

jon pill (7/13/2010)
What is wrong with the post, it is orderly?
Nothing is wrong if you don't mind either verbal-only answers, swags, or incorrect code. People like to test their...
--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)

July 14, 2010 at 12:08 am

#1192562
RE: Free online SQl server?

Grant Fritchey (7/12/2010)
Microsoft frequently will give you limited time access to a server online for training purposes. Go here and check it out.
Just make sure you follow the licensing rules...
--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)

July 14, 2010 at 12:01 am

#1192557
RE: Query help..

LutzM (7/12/2010)
Here's the approach I would use:
SELECT
t1.id,
t1.fromdt,
t1.todt
FROM [test2] t1
WHERE EXISTS
( SELECT 1
FROM [test2] t2
WHERE t1.id ...
--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)

July 13, 2010 at 11:57 pm

#1192554
RE: Help in building query to generate a view

raj.lath-932078 (7/13/2010)
Tables are
1.Med Fields are MedicineCode primary varchar(10)
MedicineName ...
--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)

July 13, 2010 at 11:46 pm

#1192544
RE: xp_cmdshell question

I probably wouldn't give a vendor such access. I'd ask them to tell me what they wanted and how to get it. Then, I'd email the results.
--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)

July 13, 2010 at 11:41 pm

#1192543
RE: xp_cmdshell

river1 (7/12/2010)
Hi,
I execute a command (xp_cmdshell) , but i always receive this error:
Login failed for user 'teste'.
But the user is sysadmin and the password is correct.... and the functionality...
--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)

July 13, 2010 at 11:36 pm

#1192541
RE: Importing CSV files in sql with Double quotes

christopher.hawkes (7/13/2010)
1st ever post so apologies if this isn't in the correct forum....
I have a CSV file that I'm trying to import but every record (not field) is enclosed in...
--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)

July 13, 2010 at 11:30 pm

#1192539
RE: Becoming a business intelligence architect

steveb. (7/13/2010)
You should look at getting a MSBI certification, however you will need a lot more than passing exams to become a BI architect. You would need...
--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)

July 13, 2010 at 11:25 pm

#1192535
RE: Character type number convert

sampathsoft (7/13/2010)
In my table field records storing char type . That records like
1
1.1
1.1.3
1.2 ...
--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)

July 13, 2010 at 11:24 pm

#1192533
RE: Maintaining Common Functions & Procedures Across Multiple Servers

I have to take pretty good exception to what has been stated so far. Cross Database Functions are NOT slow. Cross Server Functions are can be.
On my current...
--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)

July 13, 2010 at 11:11 pm

#1192523

Viewing 15 posts - 37,666 through 37,680 (of 59,072 total)