Viewing 15 posts - 57,991 through 58,005 (of 59,067 total)
Thanks, DC and Ieea,
I always thought cursors were a part of SQL Server... didn't know they were actually added as a "feature"
at...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2006 at 5:57 am
Just following up... here's a cool problem that I just ran across that I was able to answer because I'd done something like it before...
Here's the problem...
You have a payment...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 10:58 pm
Absolutely concur! I was just demonstrating one method of getting the CPU time expended by a single spid. I usually get the I/O the same way as well as measuring...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 10:08 pm
Reet,
You'll undoubtably get several suggestions using a self-joined correlated sub-query which are usually pretty darned slow. They'll usually take about 29 seconds to do 10,000 records and the duration get's exponentially...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 9:24 pm
To summarize your request for a view to simply reject those things where "somecolumn" has things in it besides numeric digits...
CREATE VIEW dbo.someviewname
AS
SELECT somecolumns...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 6:52 pm
Ummmm.... press the {f8} function key...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 6:43 pm
Thought I'd throw one of my own into the circle...
If you don't have a "Tally" or "Numbers" table, now is as good a time as any to make one. A...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 6:24 pm
Jacques,
I'm not sure how your example helps because the cpu time you produce is for the entire server, not an individual spid... as you said about simple elapsed time, if...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2006 at 5:30 pm
I have to admit... I've never seen an ideally designed database
(usually, too many cooks in the design with too little knowledge, you know...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2006 at 7:01 pm
I'm thinking that's likely true because, as someone else pointed out, the TEMPDB database is set to the "SIMPLE" recovery mode. However, most other operations on temp tables are logged......
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2006 at 6:29 pm
If I understand the problem correctly... this might be a good job for a trigger.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2006 at 8:16 pm
... of course, there are no possibilities when you don't respond to the people trying to help. ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2006 at 7:14 pm
Does anyone have a Microsoft reference or test code to support that one? I'm kinda in the "Myth Buster" mode at work about Temp Tables and Table Variables... anything you...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2006 at 9:56 pm
Simple obfuscation using Exclusive-OR is fine for keeping the honest man honest...
But one of the first things hackers do on an SSN column is something like this...
1. Take a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2006 at 7:24 pm
SG,
We can help but we need to see some examples of the dates... as you can see from the posts above, there are a lot of possibilities...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2006 at 2:51 pm
Viewing 15 posts - 57,991 through 58,005 (of 59,067 total)