Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,996 through 32,010 (of 59,099 total)

RE: Really large LDF file

MyDoggieJessie (11/8/2011)
Understood Jeff, but if there will be queries like that running again (safe to say that it will happen again) then wouldn't it be considered a good practice 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)

November 9, 2011 at 7:46 am

#1405189
RE: sp_cursoropen very slow on 1 table on 1 server but other tables/servers are ok

sotn (11/8/2011)
so their table/content is different
What about the collation of the character based columns of that table? COLLATION can make a HUGE impact on performance and, IIRC, 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)

November 9, 2011 at 6:04 am

#1405093
RE: Trancender too simple?

michael.french 172 (11/8/2011)
I had memorized the answers to many of their questions
That's the reason why many people fail the cert exams. Memorization without understanding won't help you if 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)

November 8, 2011 at 8:00 pm

#1404944
RE: Really large LDF file

MyDoggieJessie (11/8/2011)
To reinforce NJ-DBA...
There is some reason that the file grew to 50GB. Usually we say, "leave the file as big as it grows to- if it got that big,...
--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 8, 2011 at 7:27 pm

#1404941
RE: Help with a searching a string within a specified word proximity

You could spend a whole lot of time and money on this. For example, what is a word? As well as the normal "separated by spaces" requirement, what...
--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 8, 2011 at 7:20 pm

#1404939
RE: Need nudge with logic to use in dynamic SQL statement to delete duplicate FKs

That's a start. Are you sure you have no FKs with intermediate digits? Also, have you verified by definiton that the FKs are actually duplicates?
--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 8, 2011 at 6:57 pm

#1404932
RE: Real Time Dangers

Great editorial, Steve. Thanks.
--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 8, 2011 at 6:49 pm

#1404931
RE: execute stored procedure with order by

GilaMonster (11/8/2011)
The Dixie Flatline (11/8/2011)
daveriya (11/8/2011)
i want to order my result by 1,5 ..not with column name
Hasn't ordering by column number been deprecated?
I thought so too, but I can't find...
--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 8, 2011 at 5:38 pm

#1404927
RE: RBAR

goofbauer (11/8/2011)
I now have a new favorite. :blush: The Itzek-style cross join. Begs the question, why does MS place the emphasis they do on cursors and rCTEs in certification. 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 8, 2011 at 5:15 pm

#1404922
RE: Select the document name from a column contaning full path and file name

Fair enough... then let's tweak Paul's bit of Tally-Table-like prestidigitation with a fix that will handle trailing spaces on the file name... 🙂
SELECT
LEFT(d.OFFERT, LastBackslash.position - 1),
...
--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 8, 2011 at 4:15 pm

#1404906
RE: Starting with "WITH"

SQLRNNR (11/7/2011)
SQL Kiwi (11/7/2011)
I would happily refer to rCTEs (and nested loops plans in general) as RBR rather than RBAR; it's the 'A' that I have issues with 🙂
Mind you,...
--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 8, 2011 at 4:04 pm

#1404902
RE: Select the document name from a column contaning full path and file name

SQL Kiwi (11/7/2011)
Jeff Moden (11/7/2011)
I agree with TOM. I recommend you continue to use DATALENGTH for the very reason he stated.
Trouble is, that implementation now only works with Unicode...
--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 8, 2011 at 11:05 am

#1404733
RE: Starting with "WITH"

ChrisM@Work (11/8/2011)
Jeff Moden (11/7/2011)
...like Cursors and WHILE loops, I just want to make sure that people understand that the use of rCTEs should ~~probably~~ be avoided if there's a decent...
--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 8, 2011 at 9:30 am

#1404660
RE: converting to INT from varchar

ryvlad (11/8/2011)
I run it against some of my data and it works consistently faster than the one I have.
not by much, about 13 to 16 milliseconds faster, but still...
--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 8, 2011 at 9:10 am

#1404645
RE: Question about stored procs, xp_cmdshell, and .NET applications

[font="Arial Black"]WARNING... [/font]the following drops the xp_CmdShell proxy user and a database. Please double check to see if either will damage your system before running the script below.
Here's 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)

November 7, 2011 at 6:39 pm

#1404238

Viewing 15 posts - 31,996 through 32,010 (of 59,099 total)