Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,816 through 13,830 (of 59,095 total)

RE: CTE - Cursor - Try Catch

drew.allen - Friday, November 3, 2017 1:41 PM
rxm119528 - Friday, November 3, 2017 12:34 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 7:08 pm

#1966725
RE: CPU spike when executing a query in SQL

saum70 - Saturday, November 4, 2017 5:00 AM
Hi,
Our production environment recently have been witnessing spike in CPU utilization of more than...
--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 7:04 pm

#1966724
RE: Initial size of data file

coolchaitu - Sunday, November 5, 2017 3:51 AM
Thom A - Wednesday, November 1, 2017 10: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 5, 2017 at 6:50 pm

#1966722
RE: Core T-SQL

xsevensinzx - Sunday, November 5, 2017 2:00 AM
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 5, 2017 at 6:46 pm

#1966721
RE: Are the posted questions getting worse?

Lynn Pettis - Sunday, November 5, 2017 6:00 PM
So, today is not what I expected. My dad's right femur broke causing him...
--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 6:26 pm

#1966718
RE: Date Ranges - Simple, but seemingly impossible

Vegeta7 - Sunday, November 5, 2017 8:17 AM
Eirikur Eiriksson - Sunday, November 5, 2017 2:02 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 5, 2017 at 5:52 pm

#1966716
RE: import .BCP files into sql server

Ok... just in case you haven't figured it all out...
1. There is no need for BCP here.
2. There is no need for a BCP format file here.
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)

November 5, 2017 at 5:30 pm

#1966715
RE: import .BCP files into sql server

Ah, my apologies. I lost track of this one.
Did you suss this or do you still need help?
--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:54 pm

#1966713
RE: Collect data en show it in a graph

You could just setup and Excel spreadsheet to hit a stored proc and do automatic refreshes to update a chart in Excel.
The question is, what kind of...
--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:27 pm

#1966712
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

Viewing 15 posts - 13,816 through 13,830 (of 59,095 total)