Viewing 15 posts - 41,071 through 41,085 (of 59,069 total)
You've correctly identified the problem which is 90% of the solution... Take a peek at SUBSTRING and CHARINDEX in Books Online to get the rest. Heh... I'd show you...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 9:47 pm
scheney-1152259 (11/20/2009)
I guess it's obvious that I'm not an SQL expert; I need help with a basic query:
--I have a DB called 'CIMPLICITY'
...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 7:04 pm
Good DBA's know how to find such things on their own. 😉 At least they'll try on their own, first.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:56 pm
SQL Learner-684602 (11/20/2009)
I have a query to get % from two summed columns it gives me correct % but the zeros are not going off, even if I use...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:35 pm
What do you get for the following?
SELECT COUNT(*)
FROM TABLE A
WHERE A.iRowID Between 1 and 100
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:27 pm
As a bit of a side bar... take a look at the WITH ROLLUP and WITH CUBE options on the GROUP BY and the GROUPING function that goes along with...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:25 pm
Steve Jones - Editor (11/20/2009)
Now I want a steak for dinner, but my wife put a turkey in 🙁
At least it's not that "Tofurky" garbage...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:06 pm
My point exactly.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:04 pm
Gianluca Sartori (11/20/2009)
My steak recipe is the shortest ever:
* volcano hot grill
* raw...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 4:07 pm
Nadrek (11/20/2009)
C# Screw (11/20/2009)
I think DBA folk are interested in CPU time to see if the server is being strained? but that could be seen by looking at CPU Percentage...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 3:52 pm
C# Screw (11/20/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 10:40 am
Michael Meierruth (11/20/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2009 at 6:23 am
Heh... last but not least... if you want to see all of the T-SQL code example really start dragging their feet, just change the datatype of the column being cleaned...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2009 at 9:33 pm
Paul White (11/19/2009)
Paul White (11/19/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2009 at 9:12 pm
Paul White (11/18/2009)
The performance of the code in the article (unless I have really messed up) seems very dependent on collation. For a long time yesterday, I couldn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2009 at 9:09 pm
Viewing 15 posts - 41,071 through 41,085 (of 59,069 total)