Viewing 15 posts - 511 through 525 (of 2,462 total)
pallavi.unde (1/14/2013)
i want to concat row with comma separator and before that need to add one statement which is common ..
post the sample data with expected output
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 5:00 am
post the definition of all related queries along with view
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 3:41 am
M@hesh (1/13/2013)
Job is taking much time to execute, when i check the Wait type it shows 'Sleep_Task' and there is no blocking in the server.
it can, but for better...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 3:07 am
yogesh.bhor (1/14/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:58 am
yes, you can try Checkdb and at a side , i will suggest again go through the link which i posted above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:54 am
steve 50602 (1/13/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:47 am
anthony.green (1/14/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:44 am
I dont think disk shortage could lead to torn page, it generally happens because of system/disk outage.
see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:39 am
anthony.green (1/11/2013)
Full text indexing would be an option using the contains clauseSELECT ..... FROM SomeTable
WHERE CONTAINS(ColumnName, 'abc or def or ghi ....... ')
+ 1
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:34 am
anthony.green (1/14/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:26 am
Vedran Kesegic (1/11/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:23 am
anthony.green (1/14/2013)
Could you not re-write the app to use connection pooling instead of spawning a new SPID as and when the app needs it?
A side question , can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:19 am
i think "insert into select " provide better readabilty when we use this approach in "long time used queries/stored proc". we can easily see what are the columns and what...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 1:28 am
Another thing which we can try here is
----instead of
WHERE StatementID IN (SELECT StatementID FROM MyDB_ARCHIVE.dbo.StatementHeader)
-----test it
WHERE exists (SELECT 1 FROM MyDB_ARCHIVE.dbo.StatementHeader A where A.StatementID =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 5:09 am
beyan (1/11/2013)
I will try to see if i can get the identity columns out.
for indentity columns , check the column is_identity in sys.columns table , its a bit wise...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 4:45 am
Viewing 15 posts - 511 through 525 (of 2,462 total)