Viewing 15 posts - 1,081 through 1,095 (of 2,462 total)
its is happening because of white spaces in folder's name "program files"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2011 at 1:45 am
daveriya (5/3/2011)
i want to delete all the records from 2 tables ,that r link with pk->fk
for ex, emp : empid ,name
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2011 at 1:32 am
If the user(login ) exists there then it will be pulled out by
select * from syslogins where name like '%' + @User + '%'
Are you not getting...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2011 at 6:31 am
Production server!! and if you are using same disk for both user DBs and temmpdb , then start thinking to move tempdb on different disk.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2011 at 6:16 am
Vinod,
During online indexing sql takes space from the current DB for temporary storage of data.there is one option "SORT_IN_TEMPDB" . keep it ON so that tempdb can be used...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2011 at 4:52 am
Ninja's_RGR'us (3/11/2011)
What's the impact on your system? Are you dropping below required perf levels?
Have you actually tested it?
actually posted ones are some suggestion to improve the DB performance and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2011 at 8:28 am
Ninja's_RGR'us (3/11/2011)
What's the impact on your system? Are you dropping below required perf levels?
Have you actually tested it?
actually posted ones are some suggestion to improve the DB performance and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2011 at 8:28 am
Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.
1 manage your DB on multiple disk.
2...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2011 at 7:49 am
Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.
1 manage your DB on multiple disk.
2...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2011 at 7:49 am
hi varun, can u tell us any specific reason why you don't want to use CTE?if the other approach the comparatively expensive.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2011 at 8:32 pm
hi varun, can u tell us any specific reason why you don't want to use CTE?if the other approach the comparatively expensive.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2011 at 8:32 pm
THis link can help you to undestand the working of TempDB http://technet.microsoft.com/en-us/library/cc966545.aspx#EDAA
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2011 at 12:07 am
DId you have any heavy migration in recent past ? or any sql level code changes ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2011 at 6:49 am
SQLkiwi (3/4/2011)
SELECT Invitee_ID =
CASE
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2011 at 6:36 am
Read this
http://technet.microsoft.com/en-us/library/cc966545.aspx
http://msdn.microsoft.com/en-us/library/ms175527.aspx
http://support.microsoft.com/kb/307487
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2011 at 1:38 am
Viewing 15 posts - 1,081 through 1,095 (of 2,462 total)