Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,906 through 16,920 (of 59,067 total)

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
RE: extract tar.tz file in SSIS

If it worked for you from the CMD prompt but it does work from SSIS, I have to ask... is SSIS on the same machine that you had the successful...
--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 6:50 pm

#1897929
RE: finding application name

jkramprakash (8/26/2016)
How to find whether Microsoft visual studio or asp application accessing my SQL server?finding that application name.
sp_who2 will have that info as live data.
--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 6:35 pm

#1897926
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

CELKO (8/26/2016)
It would be much better to convince the "developers" that FLOAT is the wrong thing to use unless the scale of the number varies in an astronomical way.
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)

August 26, 2016 at 9:06 am

#1897837
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

waxingsatirical (8/26/2016)
While I have your attention though... how do you get around the decimal rounding problem:
declare @a decimal (38,28) = 1.123456789
declare @b-2 decimal (38,28) = 1.123456789
declare @c decimal (38,28) =...
--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 8:50 am

#1897830

Viewing 15 posts - 16,906 through 16,920 (of 59,067 total)