Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,306 through 25,320 (of 59,099 total)

RE: Are the posted questions getting worse?

jasona.work (11/26/2013)
/rant mode on
Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle...
--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 27, 2013 at 7:52 am

#1669486
RE: Are the posted questions getting worse?

Greg Edwards-268690 (11/23/2013)
L' Eomot Inversé (11/23/2013)
Ed Wagner (11/22/2013)
I never had the "pleasure" of working with either of those IBM products, but I've been forced to work with other ones. ...
--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 27, 2013 at 7:50 am

#1669485
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Paul White (11/26/2013)
I've just noticed that "IsAllDigits" includes fractions:
-- True
SELECT IsAllDigits
FROM dbo.IsAllDigits('1¼');
-- True
SELECT IsAllDigits
FROM dbo.IsAllDigits('¾5¼');
Collation-related of course. There is more between 0 and 9 than just the integers....
--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 27, 2013 at 7:24 am

#1669479
RE: Visitor Parking

Japie Botma (11/27/2013)
I would just change one thing on Jeff's suggestion: Use a wheel clamp instead of towing. In our country it is a cheaper option and if...
--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 27, 2013 at 6:59 am

#1669465
RE: Free Disk Space by Clearing Columns ?

I also believe that type of thing will only work on variable length columns, as well.
--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 26, 2013 at 9:11 pm

#1669318
RE: Visitor Parking

Gosh. I believe this is real simple.
The signs should say that you'll be towed after 2 hours UNLESS you register your vehicle with the folks inside. That way...
--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 26, 2013 at 9:08 pm

#1669317
RE: Extract string

kapil_kk (11/26/2013)
David Burrows (11/26/2013)
One way
SUBSTRING(@string,CHARINDEX('_',@string)+1,CHARINDEX('_',SUBSTRING(@String,CHARINDEX('_',@string)+1,255))-1)
Thanks David,:-)
I have implemented in the same manner..but I am looking for another solutions for this
Ok... your turn. Why did you need 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 26, 2013 at 9:04 pm

#1669315
RE: Core T-SQL

ChrisM@Work (11/26/2013)
Interesting you should go beyond "core skills" here, Jeff. Over the last year or two I've been compiling a list of skills which I think a "senior SQL Server...
--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 26, 2013 at 6:57 pm

#1669302
RE: Core T-SQL

ChrisM@Work (11/26/2013)
Interesting you should go beyond "core skills" here, Jeff.
Heh... "Core Skills" for a Database Developer or a DBA. You might as well say "breathing" with as low...
--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 26, 2013 at 1:28 pm

#1669260
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

There are also a wad of paging methods in the following discussion.
http://www.sqlservercentral.com/Forums/Topic672980-329-1.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)

November 25, 2013 at 10:15 pm

#1669022
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

Ok, here we go. The first thing that we need is some test data. Heh… I couldn’t bring myself to put a telephone number in an NVARCHAR column...
--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 25, 2013 at 9:51 pm

#1669019
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

All it has to do is happen once on my machines and I'm screwed. And monitoring for something means that it has already happened and the monitor log then...
--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 25, 2013 at 6:06 pm

#1669009
RE: Please help ... Attaching all files in a folder to an e-mail

If you don't need the file details like the date created or size, then you can use xp_DirTree to get a list of the files instead of a CLR. ...
--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 25, 2013 at 3:08 pm

#1668993
RE: Question for DBAs - Manage SQL Jobs

keyun21 (11/25/2013)
Their response is to go and figure out yourself.
Not exactly "Exceptional DBAs", in my book. :blink: The link that Lowell provided is definitely the place to start.
--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 25, 2013 at 3:00 pm

#1668992
RE: Backup Time vs Restore Time

I have a 141GB database that takes 00:31:05 to backup and and 01:31:27 to restore. I don't know if the 3:1 ratio exists elsewhere but, as you can see,...
--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 25, 2013 at 2:22 pm

#1668976

Viewing 15 posts - 25,306 through 25,320 (of 59,099 total)