Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,521 through 20,535 (of 59,098 total)

RE: Creation of random password which is easy to remember!!

SQL-DBA-01 (6/2/2015)
Thnx Lowell for giving me the approach and the nice script indeed. Many thnx.
Hi Luis
I can go to online site to steal their password if incase I have 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)

June 2, 2015 at 8:11 pm

#1802485
RE: Table Locking & Killed/Roll-back Session Issue

This is a tough one. You have to find the connection on the DB2 side of the house and kill it before the SQL Server connection will rollback.
--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 2, 2015 at 8:03 pm

#1802484
RE: Query assistance....

Ozzmodiar (6/2/2015)
I see you have a perfectly valid solution, so I won't bother typing it all up unless you're interested.
There is a very elegant solution to this problem using 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 2, 2015 at 7:59 pm

#1802482
RE: Missing Identity Numbers

Frank Cazabon (6/2/2015)
Thanks to all, especially the link to the bug when restarting the service.
It's actually not a "BUG". It's a performance feature. They preallocate 1,000 IDs to...
--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 2, 2015 at 7:56 pm

#1802481
RE: Running totals with OVER clause

devsql123 (6/2/2015)
Hi Folks i am in similar situation...can you please see my post and reply me.
My Post title is: "Trying to get running Total in SQL Server"
Thanks
Devsql
Eirikur's most recent answer...
--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 2, 2015 at 5:52 am

#1802249
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

While this is a good example and it's a good article (thank you SQLMickey for taking the time to write it), it IS an example of 1. "Divide'n'Conquer" methods...
--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 2, 2015 at 5:18 am

#1802244
RE: A Case FOR Cursors...

There's a pretty good chance on most systems that 1) 100,000 rows would not cause a 1.3 second blip. It would normally take an order of magnitude higher number...
--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 1, 2015 at 9:30 pm

#1802213
RE: Are the posted questions getting worse?

Maybe it's just me. I might be getting too old for this business. I don't understand why people make such ridiculous posts.
http://www.sqlservercentral.com/Forums/FindPost1690570.aspx
--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 1, 2015 at 8:05 pm

#1802204
RE: Find out the size of database tables, row count, data size, index growth

mark.the.dba (6/1/2015)
I updated the script to handle tables in different schema's. I was using this today and found I have issues when the tables had different schema's.
/quote]
I hope they...
--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 1, 2015 at 8:00 pm

#1802202
RE: Find out the size of database tables, row count, data size, index growth

mark.the.dba (6/1/2015)
I updated the script to handle tables in different schema's. I was using this today and found I have issues when the tables had different schema's.
I hope they...
--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 1, 2015 at 8:00 pm

#1802201
RE: Combining Temp Table Results

Union all should have worked but it's impossible to tell without seeing your code, at the very least.
--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 1, 2015 at 7:50 pm

#1802200
RE: xp_cmdshell --> "Access is denied."

The login for SQL server doesn't have the necessary privs on either the source, the target, or both. You do.
--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 1, 2015 at 7:49 pm

#1802199
RE: CLR function performance difference same server different database

... sorry... bad post removed.
--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 1, 2015 at 8:22 am

#1802004
RE: A Case FOR Cursors...

qbrt (6/1/2015)
RonKyle (6/1/2015)
Sometimes we use CURSORS in our order processing environment to move data between systems and changing statuses on each record processed. The main reason for using a cursor...
--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 1, 2015 at 8:15 am

#1801999
RE: A Case FOR Cursors...

peter.row (6/1/2015)
Added a cursor just the other week when a recursive CTE used in a cross apply was causing a query to take over the .NET default 30 second timeout...
--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 1, 2015 at 8:10 am

#1801995

Viewing 15 posts - 20,521 through 20,535 (of 59,098 total)