Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,976 through 24,990 (of 59,099 total)

RE: Stop/Start SQL Server Agent

What privs do you have on SQL Server itself? Do you have "SA" privs? If not, you're pretty much stuck. If you do, then it may be...
--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 31, 2013 at 9:35 am

#1676619
RE: Difference Between Maximum and Minumum Values

Thinky Night (12/31/2013)
Thanks a lot. Happy New Year.
Let's start the new year off right. Do you understand how and why the solution works?
--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 31, 2013 at 9:28 am

#1676616
RE: How yo make these two queires to one please

Christian Graus (12/30/2013)
Jeff Moden (12/30/2013)
kapil_kk (12/29/2013)
Please do not post duplicate post in different forums it will save other people time too..
Actually, I would have done the same thing if 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 31, 2013 at 8:52 am

#1676608
RE: Any way to speed up a shrink DB operation?

jasona.work (12/30/2013)
I'm going to be taking a backup of a DB tomorrow, then restoring a copy of it for some testing by the Dev and Customers. The server this...
--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 30, 2013 at 9:58 pm

#1676516
RE: How yo make these two queires to one please

kapil_kk (12/29/2013)
Please do not post duplicate post in different forums it will save other people time too..
Actually, I would have done the same thing if I thought the answer 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 30, 2013 at 9:36 pm

#1676513
RE: How yo make these two queires to one please

Christian Graus (12/30/2013)
Funny enough, I got a notification that told me where the other thread was. For anyone interested in seeing the other solutions offered, it's here:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/de788fa8-2767-47bc-a29e-f50e5245e955/how-yo-make-these-two-queires-to-one-please?forum=transactsql
Thanks, Christian. ...
--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 30, 2013 at 9:33 pm

#1676512
RE: PIVOT on months

Quite naturally, I like the following article on Dynamic Pivots better. 😉
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 30, 2013 at 9:19 pm

#1676510
RE: ShrinkFile on large database with TRUNCATEONLY

samalex (12/30/2013)
We have a large OLAP database, about 2.5 TB spread out over 3 data files on three different drives, and recently someone ran a query that created 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 30, 2013 at 8:48 pm

#1676509
RE: Dynamic Mapping for XML in SSIS?

Phil Parkin (12/30/2013)
In short, Dynamic mapping is possible in xml & ssis?
Not out of the box.
In the case you've mentioned, it's probably easiest to set up two data flows which...
--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 30, 2013 at 8:08 am

#1676391
RE: need help on design of database for student registration system

Grant Fritchey (12/30/2013)
Jeff Moden (12/29/2013)
Grant Fritchey (12/18/2013)
I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about 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)

December 30, 2013 at 7:56 am

#1676389
RE: How yo make these two queires to one please

Christian Graus (12/30/2013)
I frequent several SQL forums, I don't even recall now which one I saw it on, but I did suggest using a CTE, and gave an 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)

December 30, 2013 at 7:36 am

#1676378
RE: Concept of Data and Index pages

sql crazy kid (12/29/2013)
Jeff Moden (12/29/2013)
As well as the marvelous articles that Gail posted, Books Online has some great information in it (if you don't know what Books Online is,...
--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 29, 2013 at 10:49 pm

#1676292
RE: Dynamic Mapping for XML in SSIS?

Let me "bump" this one for you, Karthik. I'm interested in an answer to this general question, as well.
--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 29, 2013 at 10:45 pm

#1676291
RE: i want to have my primary key as out put , when i insert a record!

nazaninahmady_sh (12/28/2013)
Hi
I have a store procedure, I want when I insert a record, I can have its id (Poll_ID, it is my primary key) as a output , would...
--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 29, 2013 at 10:29 pm

#1676290
RE: How yo make these two queires to one please

Christian Graus (12/28/2013)
It's really kind of rude to post the same question on many different forums, instead of just taking part in a community somewhere.
This has been answered, by me,...
--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 29, 2013 at 2:53 pm

#1676281

Viewing 15 posts - 24,976 through 24,990 (of 59,099 total)