Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,831 through 13,845 (of 59,101 total)

RE: When a database last accessed (Insert/Update/Delete/Select)

Another way is to check sys.dm_db_index_usage_stats () with the understanding that it's cleared out every time the SQL Server Service is started or restarted.
--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)

November 5, 2017 at 3:24 pm

#1966711
RE: Import multiple excel files in one go

How did you import that single spreadsheet, so far?
--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)

November 5, 2017 at 3:21 pm

#1966710
RE: how to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts

SQLPirate - Thursday, October 26, 2017 6:42 PM
Sure thing.
Here's Microsoft's extract page and example... I don't actually like this one,...
--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)

November 5, 2017 at 1:36 pm

#1966709
RE: Encrypt a column in sql server?

vsamantha35 - Sunday, November 5, 2017 10:54 AM
Hi Jeff.
Thanks for valuable suggestions. This is just a POC kind of thing try...
--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)

November 5, 2017 at 11:46 am

#1966707
RE: Encrypt a column in sql server?

Thom A - Sunday, November 5, 2017 3:00 AM
Jeff Moden - Saturday, November 4, 2017 8:42 PM
--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)

November 5, 2017 at 9:48 am

#1966704
RE: Encrypt a column in sql server?

vsamantha35 - Sunday, November 5, 2017 5:47 AM
So, in general how are we going to share the key? Is that by taking...
--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)

November 5, 2017 at 9:42 am

#1966703
RE: Encrypt a column in sql server?

vsamantha35 - Sunday, November 5, 2017 12:53 AM
Sorry my bad. I want to encrypt and not masking the data. Editing the original...
--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)

November 5, 2017 at 9:32 am

#1966702
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 8:20 PM
Jeff Moden - Saturday, November 4, 2017 7:36 PM
--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)

November 4, 2017 at 9:15 pm

#1966678
RE: Encrypt a column in sql server?

vsamantha35 - Saturday, November 4, 2017 2:46 PM
Hi All,
Need help in encrypting a column and share the encryption key with...
--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)

November 4, 2017 at 8:42 pm

#1966677
RE: The Importance of Clear Data Displays

Ooooo... don't get me started. This was a stupid mistake on all fronts including the human checks and balances that are supposed to be in place even for such mundane...
--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)

November 4, 2017 at 8:36 pm

#1966676
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 5:23 PM
Gary Varga - Wednesday, November 27, 2013 2:06 AM
--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)

November 4, 2017 at 7:36 pm

#1966674
RE: Core T-SQL

TomThomson - Saturday, November 4, 2017 5:08 PM
Jeff Moden - Friday, November 29, 2013 10:37 AM
--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)

November 4, 2017 at 5:18 pm

#1966672
RE: Changing NVARCHAR to VARCHAR...

GilaMonster - Friday, November 3, 2017 9:13 AM
Jeff Moden - Thursday, November 2, 2017 9:23 PM
--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)

November 4, 2017 at 5:11 pm

#1966671
RE: Send Job Alerts to User Base

ThomasRushton - Thursday, November 2, 2017 4:48 AM
When setting up the SQL Server scheduled jobs, what you could do is add a...
--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)

November 3, 2017 at 6:15 pm

#1966645
RE: CLR to write to the Windows Event Log

Phil Parkin - Friday, November 3, 2017 8:18 AM
Jeff Moden - Friday, November 3, 2017 8:05 AM
--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)

November 3, 2017 at 1:03 pm

#1966615

Viewing 15 posts - 13,831 through 13,845 (of 59,101 total)