Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,386 through 20,400 (of 59,072 total)

RE: How to use a year and month fields to get a range of records

waynes 78578 (6/11/2015)
Well my previous post didn't actually work for all options, hopefully this does.
I find it's a very common problem with accounting tables, which often only store the year...
--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)

June 11, 2015 at 8:41 am

#1804713
RE: Need help for paaing table name and date as variable in dynamic sql

srgaddam2 (6/10/2015)
Jeff,
I am new to SQL server, so I would appreciate if you could help me understand the SQL hacking concept. What is the purpose of quotename? How 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)

June 11, 2015 at 8:24 am

#1804708
RE: prevent sysadmin for access

snuthalapati (6/10/2015)
Thank you for the reply...
How about any auditing kind???
I believe you'd need something 3rd party like Guardium (if I got the name right).
--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)

June 10, 2015 at 9:13 pm

#1804561
RE: Need help for paaing table name and date as variable in dynamic sql

Ok... first of all, that query is susceptible to SQL Injection, which is still the leading cause of successful hack attacks. At the very least, wrap a QUOTENAME around...
--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)

June 10, 2015 at 8:08 pm

#1804557
RE: Group by issue

karen.blake (6/10/2015)
I am getting into this lovely stuff again, when you say table structure what do you need? Column types or how the tables fit together for example?
Hi and welcome...
--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)

June 10, 2015 at 7:54 pm

#1804556
RE: script to Find current date modify table list

charipg (6/10/2015)
i need to find out the table names which are [font="Arial Black"]modified in last 24hrs[/font].
SELECT * FROM sys.tables WHERE modify_date >= DATEADD(dd,-1,GETDATE());
--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)

June 10, 2015 at 7:47 pm

#1804555
RE: Mask the data during restore

snuthalapati (6/10/2015)
How can we mask the sensitive data when I am restoring the production backup to DEV database
for ex: we have SSN details in prod, how can mask the sensitive...
--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)

June 10, 2015 at 7:27 pm

#1804553
RE: prevent sysadmin for access

snuthalapati (6/10/2015)
How to prevent sysadmin user for not to access the data in the database.?
You pretty much can't.
--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)

June 10, 2015 at 7:26 pm

#1804551
RE: performance history

snuthalapati (6/10/2015)
how can we track any database performance issues for last week?? (in a particular date/time). Any DMVs?
You might be able to find something left over in the DMVs but...
--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)

June 10, 2015 at 5:46 pm

#1804547
RE: Need help for paaing table name and date as variable in dynamic sql

srgaddam2 (6/10/2015)
Hi,
I need some help in building the dynamic sql . When I create below script and executed the procedure passing the table name and date values its giving...
--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)

June 10, 2015 at 5:42 pm

#1804546
RE: SQL Server Data Lost on User DB's

ericpap (6/10/2015)
Jeff Moden (6/10/2015)
ericpap (6/8/2015)
I'm facing a very complex situation with my software databases on a specific server. This is the second time this problem happend on this server. Basically...
--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)

June 10, 2015 at 5:26 pm

#1804544
RE: Insert without a PK

Bobby Russell (6/10/2015)
1st answer WAS the correct answer. I tested it after I got it wrong. There is nothing in any of this about disabled indexes. Are you missing some...
--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)

June 10, 2015 at 9:31 am

#1804386
RE: SQL Server DBA or BI

dniranjan2000 (6/10/2015)
Jeff Moden (6/9/2015)
dniranjan2000 (6/9/2015)
Dear Friends,
I am new to SQL Server, working as an IT support for the past 7 years and want to move to SQL
I am learning TSQL...
--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)

June 10, 2015 at 8:44 am

#1804369
RE: Index rebuild slow on 2014

What is the recovery model of the two servers? Also, what are the growth rates for the database on the new machine? Last but not least, are 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)

June 10, 2015 at 8:10 am

#1804355
RE: Normalizing a database

madan.preeti2005 (6/10/2015)
No, any start up article will be helpful.
The book at the following link is probably the worlds best on the subject and it's written in such a fashion 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)

June 10, 2015 at 8:07 am

#1804354

Viewing 15 posts - 20,386 through 20,400 (of 59,072 total)