Viewing 15 posts - 1,636 through 1,650 (of 2,462 total)
i dont think you can see the older version of Sp unless you are preserving it in Audit table with the help of DDL trigger.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 6:07 am
This table has only 700 rows and its showing fregmentation > 83% with following query i found that it should be REBUILD
HOw did you figure out this ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 4:43 am
paul.corujo (6/2/2010)
The sp in question run in SSMS in under 1 second. How would I determine why it is taking more than 30 when called via the application.
if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 4:32 am
dave-dj (6/3/2010)
the problem is I get - variable .... not defined as a scalar value.
post your script
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 4:10 am
Shamshad Ali (6/3/2010)
while the same was test on applying indexes on FKeys without any performance improvements (reads/CPU/Duration) No change.
that depends on the volume of data.i guess you don't have high...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 3, 2010 at 2:11 am
Shamshad Ali (6/2/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 11:34 pm
i would say
1 run the exec plan.
2 capture the scans and lookup there.
3 modify/create indexes.
4 again run the exec plan to see the improvement.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 6:24 am
Ravi-376012 (6/2/2010)
FName VARCHAR(50) NOT NULL,
LName VARCHAR(50) NOT NULL,
Address1 VARCHAR(255),
Address2 VARCHAR(255),
----,
StateID INT,
.....)
Now I have two options one is to have a State lookup table using
StateID...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 6:20 am
PradeepVallabh (6/1/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 6:11 am
elutin (6/2/2010)
--We need to copy the data from the master table...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 5:50 am
Always try to keep column's name and their datatypes same.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 4:48 am
post your problem according to the article referred in my signature to get faster response
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 31, 2010 at 10:44 pm
halifaxdal (5/31/2010)
execute a sp or fn on a linked server with a read-access account but execute it as another account (not knowing the password)?
i dont think it can be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 31, 2010 at 10:43 pm
it could be because of windows patch or sql server patch/Service pack
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 31, 2010 at 10:26 pm
Jacob Pressures (5/27/2010)
these files were hard to even remove from the data folder.
take the database offline and then take out the mdf
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 28, 2010 at 8:01 am
Viewing 15 posts - 1,636 through 1,650 (of 2,462 total)