Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,936 through 16,950 (of 59,101 total)

RE: Mortgage amortization table

Sergiy (8/29/2016)
Jeff Moden (8/29/2016)
Someone would have to prove that one to me, Sergiy.
It took 2 minutes:
DECLARE @Amount MONEY, @Term INT
DECLARE @fRate float, @dRate decimal (38,10)
SELECT @Amount = 1000000, @Term...
--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)

August 29, 2016 at 9:18 pm

#1898205
RE: OPENROWSET linked server "(null)" error

Ah, my apologies. I didn't look at what your code was doing and went only by your description. I thought you were returning something besides the print statement.
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)

August 29, 2016 at 8:48 pm

#1898204
RE: Clustered Index Scan or Index Seek + Key Lookup

VastSQL (8/28/2016)
GilaMonster (8/28/2016)
Depends on the table size and number of rows needing a lookup. Test for your data set and see which works better for you.
Thanks Gail.
For large data scan...
--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)

August 29, 2016 at 7:53 am

#1898093
RE: OPENROWSET linked server "(null)" error

OPENROWSET returns a result set and only 1 result set. It doesn't know what to do with output from a print statement, which is a separate result set, as...
--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)

August 29, 2016 at 7:50 am

#1898092
RE: Restrict access on single database from admin user

GilaMonster (8/29/2016)
SQL_Student (8/29/2016)
will try this thanks, the issue is developers require sysadmin role on this specific box
Then that's the first thing that you need to fix, with support from management.
+Infinity...
--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)

August 29, 2016 at 7:46 am

#1898088
RE: Mortgage amortization table

Sergiy (8/29/2016)
Jeff Moden (8/29/2016)
vdiazh (8/28/2016)
Is great, thanks
I hope you're not using the FLOAT version. FLOAT is a binary "approximation" of numbers and it the scale varies according to how...
--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)

August 29, 2016 at 7:43 am

#1898087
RE: Query Performance Tuning – A Methodical Approach

GilaMonster (8/26/2016)
Jeff Moden (8/26/2016)
Grant Fritchey (6/9/2015)
There are places where partitioning can, and does, improve performance.
Apologies for the year late response and I hate to be contrary but everywhere I've...
--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)

August 29, 2016 at 6:25 am

#1898053
RE: SQL help - how do we find that a particular string appears x times in a certain field

Thanks, Matt. I sure do appreciate the testing and the feedback.
--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)

August 29, 2016 at 6:16 am

#1898046
RE: Running multiple servers script

@luismarinaray,
Both answers that you've marked as "Worked for the OP" have multiple suggestions. Which method did you ultimately end up using?
--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)

August 29, 2016 at 6:13 am

#1898045
RE: Parallel insert in a table

sqlenthu 89358 (8/29/2016)
Hi Jeff, thanks for the explanation. In my table there will be truncate load operation on monthly basis plus only few read operations. I have currently put all...
--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)

August 29, 2016 at 6:09 am

#1898043
RE: Mortgage amortization table

vdiazh (8/28/2016)
Is great, thanks
I hope you're not using the FLOAT version. FLOAT is a binary "approximation" of numbers and it the scale varies according to how many numbers are...
--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)

August 29, 2016 at 6:03 am

#1898041
RE: Table Partitioning

sanjaydut26 (8/27/2016)
Hi,
I am new to table partitioning.
I have a large table with millions of rows, There is no Date column in the table 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)

August 27, 2016 at 11:34 am

#1897957
RE: Cross Database Procedure exexcution

kasamsandeep (8/27/2016)
Hello Everyone,
I have 2 Databases DB1 & DB2 (Owner is 'sa' for both)
Table1, SP1 both exists in DB1 (Schema is 'dbo')
SP2 exists in DB2 (Schema is 'dbo')
SP1 - Does...
--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)

August 27, 2016 at 11:07 am

#1897955
RE: Got what I need, but perhaps a more elegant solution is out there. Looping through SQL filegroups to get Maxsize.

I guess I don't understand why anyone would use PoSh for such a thing when it's so easy to do in SQL Server itself. This also covers any NDF...
--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)

August 26, 2016 at 9:12 pm

#1897932
RE: Parallel insert in a table

sqlenthu 89358 (8/26/2016)
I wanted to do the same Matt and as you clarified, I get it that it's not possible. Rather I am taking a new approach now. The whole...
--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)

August 26, 2016 at 7:06 pm

#1897930

Viewing 15 posts - 16,936 through 16,950 (of 59,101 total)