Viewing 15 posts - 11,821 through 11,835 (of 26,486 total)
How many rows of data actually meet the criteia of the query?
May 21, 2012 at 12:51 pm
The restore of a compressed backup also runs faster. The difference is really down to how much faster the data is read from the backup file of the compressed...
May 21, 2012 at 12:49 pm
Depends on what I am going to be using the function(s) for in my code. Inside a SELECT list, I have learned to stay away from scalar functions. ...
May 21, 2012 at 11:38 am
Cleaned it up some:
CREATE FUNCTION dbo.itvfn_FormatTimeHHMMSS(
@TimeInSeconds INT
)
RETURNS TABLE WITH SCHEMABINDING
AS RETURN
(SELECT
CAST(@TimeInSeconds / 3600 AS VARCHAR) + ':' +
RIGHT('0'...
May 21, 2012 at 11:17 am
Really hard to give advice based on incomplete code snippits. I would look at using the OUTPUT clause and table variable(s) to pass information as well as looking at...
May 21, 2012 at 10:45 am
Here is my answer to the problem:
create table #jobhistory
(
jobId int /* really uniqueidentifier, but using int for simplicity */
,run_duration int
)
;
insert into #jobhistory
select 1,3
union all select...
May 21, 2012 at 10:30 am
You will need to use dynamic cross tabs for this. Please look at the article links below in my signature block, you will find two related to pivots and...
May 21, 2012 at 10:05 am
It starting to look obvious, at least to me, that we are starting to cross threads here and things are getting fragmented and confused. Either pick one of you...
May 21, 2012 at 7:31 am
venki83k (5/21/2012)
Hi,please explain abt detail hw can i set in a single instance db mirroring if u possible send me with screen shots also
You can't mirror a database to the...
May 21, 2012 at 7:19 am
I would say that the purpose of the question was to see how you would approach the problem to develop a solution.
May 19, 2012 at 11:07 am
SQL Kiwi (5/19/2012)
Lynn Pettis (5/19/2012)
May 19, 2012 at 9:25 am
I can see this discussion going on forever. I think it is time to stop as it is quite apparent that the author is not going to be swayed. ...
May 19, 2012 at 8:11 am
Not enough info to really help. You might use the Script Task, but without more info, just a guess. If it is an interview, you should ask for...
May 19, 2012 at 1:34 am
Steve Jones - SSC Editor (5/18/2012)
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.If you are close by, come check us out.
Enjoy! I'll be speaking downtown in Denver tomorrow...
May 18, 2012 at 2:03 pm
Viewing 15 posts - 11,821 through 11,835 (of 26,486 total)