Viewing 15 posts - 6,526 through 6,540 (of 9,643 total)
If your issue is "just" needing to reduce backup times perhaps you could move your 95% static data onto one filegroup and the larger tables onto another filegroup(s) and use...
December 19, 2008 at 7:08 am
In addition to what Chris has said you may want to do this instead as it performs a bit better:
[font="Courier New"]SELECT
*
FROM
tblcaseinfo T
WHERE
EXISTS...
December 19, 2008 at 7:02 am
Are all the databases are on the same server? If they was a different server involved I'd blame it on the server time zone setting, but I don't have...
December 19, 2008 at 6:57 am
I think you just need to do this:
insert into log values("C:\Documents and Settings\Desktop\New Folder (4)"+"substring(?,30,len(?)-30)")
The third parameter to Substring is length and using LEN(?) you are getting the entire length...
December 19, 2008 at 6:54 am
Are you able to connect to the data source using the report user name and password from elsewhere? or from another application on the report server?
December 19, 2008 at 6:47 am
You have defined a table valued function and to put it in a select list you want a scalar valued function. Be aware that using this will reduce performance....
December 19, 2008 at 6:45 am
You are the first that I know of. I was thinking about doing it on my dev server (64-bit), but now I think I'll wait until you are done.
Thanks...
December 19, 2008 at 6:39 am
Normally you allow the UI to handle formatting as they have formatting functions that are simple to use.
From BOL for converting money/smallmoney:
The following table shows the values for style that...
December 19, 2008 at 6:35 am
You would use the Hidden property under visibility. You could put an expression on it to set the value.
December 19, 2008 at 6:28 am
Prasanna,
SQL Server does not produce any trace events based on table columns. If you need to make sure you do not miss any data with a trace you need...
December 19, 2008 at 6:25 am
Sakthivel Chidambaram (12/17/2008)
But once SQL Server Agent is started, then I'm able to see the program name 'SQLAgent - Generic Refresher' in sysprocesses... Any thoughts are welcome...
Based on this you...
December 19, 2008 at 6:15 am
Could you post the solution so if someone else has the same problem and finds this thread they'll know too?
Thanks,
December 18, 2008 at 5:32 pm
I used to think the same thing. But I cannot find any documentation that states a RaisError at any level causes a rollback.
Here is all there is...
December 18, 2008 at 1:21 pm
Do you mean you want to translate the data retrieved from the database into French?
December 18, 2008 at 9:09 am
Viewing 15 posts - 6,526 through 6,540 (of 9,643 total)