Viewing 15 posts - 46,831 through 46,845 (of 49,552 total)
That will work. Just be aware that it has the potential to become a major performance problem when the tables get large.
The subquery in the select clause runs once for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 5:06 am
Ok, maybe give this a try...
It's not tested, since you didn't give table structure or sample data
SELECT Call_No,
Call_Log_Date,
Call_Resolve_Time,
Call_Downtime,
Call_Resolve_Downtime,
Call_Description,
ACTIONS_DESC...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:52 am
While number searches can be faster than string searches, you'll probably loose all your gains during the encode/decode.
A million rows aren't much to sQL server, providing your query is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:39 am
Great to hear. Nice work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:36 am
Whichever one the optimiser chooses. Don't use join hints.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:35 am
Open a new query, paste the following then run it.
DECLARE @a int
EXEC [get_form_count] @return = @a OUTPUT
PRINT @a
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:04 am
When you can read the SQL error log, please post any entries that look strange, have error severities above 19 or refer to the suspect databases.
It's important to know why...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 4:01 am
mark (4/18/2008)
If this is the case and doing extra ad-hoc backups do not make a difference, what then is the advantage of the new "copy_only" feature in 2005?
Normal full backups...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 3:55 am
Anirban Paul (4/18/2008)
As I told you I couldn't check as I found in under SQL Server 2000 in some sites.
No worries. I just wanted to clarify things
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 3:53 am
The code I posted ran fine for me, no errors. Please post the way you're calling the procedure.
QA won't prompt you for parameters like MSAccess does.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 3:21 am
What's the latest backup you have for those databases?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 3:19 am
A full backup will reset the differential base, meaning diff backups cannot be applied to an older full backup.
Neither full nor diff backups truncate the transaction log, so you should...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 3:01 am
p.beeke (4/18/2008)
AS
UPDATE form_count
SET form_count = form_count +1
I need to get the new form_count into the @return output param
I am a newbie and have not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 2:48 am
Not sure I fully understood what you want...
Here's a simple example of output parameters
CREATE PROCEDURE TestingOutput
@OutVar int OUTPUT
AS
SET @OutVar = 42
GO
DECLARE @a int
EXEC TestingOutput @OutVar = @a OUTPUT
PRINT @a
Does that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 2:10 am
What are you trying to open it with? SQL 2000's profiler won't open a trace file created with SQL 2005's profiler or server-side trace commands.
I tested and the error I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2008 at 12:48 am
Viewing 15 posts - 46,831 through 46,845 (of 49,552 total)