Jeff Moden

Forum Replies Created

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

RE: How yo make these two queires to one please

Christian Graus (12/31/2013)
I feel sorry that I opened this can of worms, I'm not sure how much benefit there is in discussing it further. My very first post there,...
--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 4:56 pm

#1676690
RE: Stop/Start SQL Server Agent

JohnFTamburo (12/31/2013)
(please disable xp_cmdshell as soon as you do this; it is a huge security hole)
No it's not. Poor ol' xp_CmdShell gets blamed for other very poor security practices...
--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 4:42 pm

#1676686
RE: Index Tuning never finishes

rummings (11/24/2013)
I have been given several large databases to tune. They have never had the statistics updated and I cannot tell when the indexes were last rebuilt. I tried to...
--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 11:22 am

#1676652
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

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