Viewing 15 posts - 676 through 690 (of 2,462 total)
anthony.green (12/18/2012)
What is the result of MAX(LEN(column)) for all the columns within the table
from nvarchar(10) to nvarchar(300) plus XML.
anthony.green (12/18/2012)
what is the datatype NameStyle?
nvarchar(30)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 18, 2012 at 4:56 am
Jason-299789 (12/17/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2012 at 11:39 pm
see this link http://msdn.microsoft.com/en-us/library/ms177500(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2012 at 3:29 am
mpradeep23 (12/17/2012)
We have a table which contains allmost 1 lak to 2 lak of records
querring on that table getting delayed give me idea how to make it faster
Thanks...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2012 at 3:27 am
Boris Pazin (12/16/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2012 at 12:12 am
gad you found the solution yourself but in future always try to post table defintion , query you tried (though its incorrect) along with test data so that people can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2012 at 12:04 am
440692 I am just a number (12/14/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 11:58 pm
1) you can use the back compression method of sql server 2008
2) is the database is in full recovery mode ?
3) if the vendors request is one time...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 11:53 pm
avdhut.k (12/16/2012)
Thanks for the reply,
But I want to excute this SP Step by Step,
And If in any one of the SP error comes then next one should...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 11:43 pm
vijayarani87.s (12/16/2012)
Thank you very much, but one more point it is a known issue in SQL.When we use linked server we may get this error.
any reference for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 11:37 pm
Noetic DBA (12/14/2012)
Also, the tempdb is growing because it is not checkpointing properly.
Did you mean to say that heavy DML operation consuming the space (like work table , tabl...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 10:36 pm
first you need to know what are these two terms
see link http://realworlddba.wordpress.com/2008/02/04/index-rebuild-versus-reorganize-whats-the-difference/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2012 at 10:29 pm
funny play 😛 😀 (to make the table empty)
use this in every database
select 'truncate table ' + name + '; ' from sys.objects where type = 'U'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2012 at 3:33 am
peter-661823 (12/14/2012)
I have also seen that TempDB growing only occurs at busineshours, in the night wíth less people working, no growing of TempDB took place.
this indicates that application (sql...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2012 at 2:28 am
Is "SEARCH PROPERTY LIST " feature available before sql 2012 ? and can it be used in sql table too ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2012 at 1:20 am
Viewing 15 posts - 676 through 690 (of 2,462 total)