Viewing 15 posts - 136 through 150 (of 203 total)
This is an example taken from BOL, as per that
March 1, 2004 at 9:28 pm
Run Profiler. and trace commands being executed by your ASP application. See the insert commands / SP fired by ASP application against your database.
If possible, put the table def...
February 29, 2004 at 11:27 pm
If your table will have seprate columns for ProjectCode and Student and your application design permits, You may even use computed Columns !!
create table test
( projectcode char(1),
studentnum int ,
...
February 29, 2004 at 11:23 pm
what does
print @sql_str
print @sql_str1
print @sql_str+@sql_str1
give you ?
February 26, 2004 at 6:24 am
one of the quick optimization is @SalesCountry variable declaration.
change it to varchar(25) as your function is only returning varchar(25).
Another piece of optimisation would be an index on dbo.sales.countrycode
see...
February 26, 2004 at 6:06 am
After a lot of Search on Internet & BOL
I found a single line in BOL under topic "External Data and Transact-SQL"
Which says that "Stored procedures are supported...
February 25, 2004 at 5:22 am
February 25, 2004 at 4:48 am
just to Add ,
Does any linked server setup with any other type of data source support connection pooling? (even when using SQL server 2000 server as a linked server data...
February 23, 2004 at 1:21 am
Try this ...
-- Amit
alter proc sp_MySpaceUsed_AllDB
as
declare @cmd varchar(255) , @db sysname
declare db cursor for
select name from master..sysdatabases where dbid > 4
if exists (select...
February 19, 2004 at 9:16 pm
Can you use IP Address instead ?
-- Amit
February 19, 2004 at 4:35 am
When you observe ther performance degradation, run sp_who and sp_lock to observe the locks (if any)
Also run a profiler trace during such period to see if any particular query is causing a...
February 18, 2004 at 11:20 pm
This is the modified version of script that you have attached.
create both procs in master database. (Note the use of @db + '..sp_MySpaceUsed ' in sp_MySpaceUsed_AllDB...
February 18, 2004 at 10:56 pm
remove TOP 100 and use following
SET ROWCOUNT 100
-- ur select query here
SET ROWCOUNT 0
What is performance impact of this ? Well as...
February 16, 2004 at 4:53 am
Trigger can not be debugged through SQL Query Analyzer..
What you can do is to stimulate the same enviornment that would be there in a trigger. i.e. create 2 tables...
February 16, 2004 at 4:02 am
Check if you have correct version of drivers loaded.
What is backup speed/time on same tape, when you use windows backup to backup equivalent sized OS files (can be other...
February 16, 2004 at 3:52 am
Viewing 15 posts - 136 through 150 (of 203 total)