Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,416 through 20,430 (of 59,098 total)

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
RE: Just want to make sure I have my facts straight about autogrowth.

Duran (6/10/2015)
Hi Jeff,
Thanks for the reply, you mentioned that it depended on a couple of things, in a nutshell, what are those things?
Regards,
D.
Pretty much what I said in my previous...
--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:03 am

#1804351
RE: Parsing large varbinary fields

Tom_Sacramento (6/10/2015)
He Jeff,
The primary key is a GUID called ID - not my idea, but this is an inherited database...
What I need is a count of each of the 3...
--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:39 am

#1804338
RE: SELECT INTO vs INSERT INTO on Columnstore

PatrickSimons (6/10/2015)
Jeff Moden (6/9/2015)
PatrickSimons (6/9/2015)
I agree 100%. Especially when you SELECT INTO inside a transaction to a temporary table (##) = worst case....
What problems have you had there? Or...
--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:37 am

#1804336
RE: SELECT INTO vs INSERT INTO on Columnstore

r.e.kiser (6/10/2015)
It's my understanding that SELECT INTO locks one or more system database tables until the data completes loading, thus preventing any other user on the entire server instance from...
--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:33 am

#1804334

Viewing 15 posts - 20,416 through 20,430 (of 59,098 total)