Viewing 15 posts - 1,351 through 1,365 (of 2,462 total)
Try with DBCC shrinkdatabase ...and if it still doesnt work ..take a full backup and then try shrinkdatabase
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 10:54 pm
Anyways ,,if you still want to shrink data file ..you can use the TRUNCATE_ONLY option in DBCC shrinkfile
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 10:44 pm
Why are you trying to shrink data file ..it can leads to fragmentation i.e poor index selection.
instead you can go for log shrinking
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 10:40 pm
What kind of lock ? Do you mean different transactional locks like shared, update locks etc ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 10:39 pm
ColdCoffee (9/6/2010)
i increased the VARCHAR to 12 and voila, i get the desired result "always"...Hmm..
yes .. but size should work according to select len('10_samjack') which is 10 which...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 6:39 am
i also caught the same as chris , varchar(10) is playing the trick , but why ? , dont know:unsure:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 6:36 am
ColdCoffee (9/6/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 5:49 am
ColdCoffee (9/6/2010)
Execute them, u will find it strange..
Still nothing.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 5:35 am
Craig Farrell (9/2/2010)
SELECT OrderID, OrderName FROM <table>WHERE LEFT( OrderName, LEN(@SearchStartsWith)) = @SearchStartsWith
this is bad from performance perspective , never use function with where caluse column , it will force sql...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 5:11 am
can you elaborate it ? i saw the exec plan but didnt get anything bad there
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:59 am
refer these links
http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:53 am
Chris Howarth-536003 (9/6/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:44 am
is your non-clustered index UNIQUE ? i dont think so
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:37 am
try two things .
try to login with sa and then look for it
and see whether that is running or not ?
and last restart the sql server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:35 am
Is that table is on dev enviroment( or local system ) or production. additionally , do you face same problem with other tables also ? my guess is "network problem"...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 4:34 am
Viewing 15 posts - 1,351 through 1,365 (of 2,462 total)