Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,201 through 19,215 (of 59,098 total)

RE: Referencing function from another database in CREATE TABLE stmt

It's not likely the function will change. If it does, you can use the Registered Server trick to push it to multiple databases in multiple servers. Just store...
--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)

November 14, 2015 at 10:21 am

#1839818
RE: The equivalent of 'connect by' in Oracle

As you've found, SQL Server doesn't have anything quite as convenient as "CONNECT BY". It's does, have a couple of tools that you can use to do similar though....
--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)

November 14, 2015 at 10:13 am

#1839817
RE: Splitting data of MDF file

vsamantha35 (11/13/2015)
Can anybody help?
To be honest, my opinion is that the drive assignments are flawed especially in light of the fact that you already know that a 10TB drive 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)

November 14, 2015 at 9:43 am

#1839813
RE: Are the posted questions getting worse?

To explain some of my extreme frustration in the "developers" that I've been interviewing over the last decade, the following blog post is a great example of the type 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)

November 14, 2015 at 8:53 am

#1839810
RE: Pounds of Formatting Fun

jamunozs (11/13/2015)
Format not exist in sql
You need to look at the newer version of SQL Server. If you're talking about ANSI SQL, few people care because this 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)

November 13, 2015 at 9:28 pm

#1839784
RE: making t-sql 2012 execute faster

wendy elizabeth (11/13/2015)
I have been working with t-sql 2012 for awhile. I have noticed that some questions run faster than other queries. I know that this is based upon 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)

November 13, 2015 at 9:25 pm

#1839783
RE: How to do a Pivot

Sean Lange (11/13/2015)
Ed Wagner (11/13/2015)
Sean Lange (11/13/2015)
Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has a slight...
--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)

November 13, 2015 at 9:15 pm

#1839781
RE: Whether my table is stored as heap or b-tree?

It's a whole lot easer than that. If the table has a Clustered index, the table will be based on a B-TREE. If it's a HEAP, it will...
--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)

November 13, 2015 at 9:06 pm

#1839779
RE: Presentation Software Recommendations

I don't see why PowerPoint couldn't do all of that. You can embed videos, setup "Credits" animations and scrolling entrances and a whole bunch of other things.
--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)

November 13, 2015 at 8:04 pm

#1839778
RE: Separate UserObejts's FileGroup And SystemObjects's FileGroup

With the understanding that you'll sacrifice a bit of performance, there are many advantages to splitting things up in separate file groups using a thing called "partitioning". It also...
--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)

November 13, 2015 at 7:41 pm

#1839775
RE: Query Performance Problem

lraju10 (11/13/2015)
Problem : currently working on purchase sproc where it is taking 2 sec for the Purchase transaction to complete, i identified the problem statement, where i generate a six...
--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)

November 13, 2015 at 7:23 pm

#1839774
RE: Pipe Delimmeted Data To Shred Into A Table

Ok... first things first. Part of the reason why you've gotten no actual code to help you for the split portion of this problem is because you haven't posted...
--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)

November 13, 2015 at 6:50 pm

#1839773
RE: Are the posted questions getting worse?

Ah... the "blood in my eyes" caused me to misread Jason's post. I thought he meant something else.
Yes. It was a hot post and I didn't really mean...
--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)

November 13, 2015 at 6:26 pm

#1839771
RE: Are the posted questions getting worse?

jasona.work (11/13/2015)
Whhoooo!!!
*I* nearly got singed by this reply: http://www.sqlservercentral.com/Forums/FindPost1736339.aspx
Not that I blame Jeff, he's probably had the "joy" of interviewing people like the OP...
I'm curious... How did you almost get...
--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)

November 13, 2015 at 5:40 pm

#1839769
RE: 4 Queries Required Very Urgent

Ed Wagner (11/13/2015)
Jeff Moden (11/13/2015)
This is actually pretty sickening. Why do you even bother going to school if you're not going to even try. You should drop 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)

November 13, 2015 at 4:13 pm

#1839765

Viewing 15 posts - 19,201 through 19,215 (of 59,098 total)