Viewing 15 posts - 526 through 540 (of 2,462 total)
Setting max memory will do the job.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 3:35 am
praveen_vejandla (1/11/2013)
Could outdated statistics be the reason behind I/O latency?
it might be . there could be another reason too like memory , IO , table/index scan happening. Please post the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 3:23 am
raghuldrag (1/11/2013)
dis for reaport purpose......
can you tell me what columns you need in report other then these tax(calculated) columns ?
and do you have any related query ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:44 am
anthony.green (1/10/2013)
Large log files do not impact performance.
A side question .
Does DML operations or index rebuild/reorg (or any other operations which grow the log file ) get impacted DURING the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:40 am
mahesh.dasoni (1/11/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:28 am
mahesh.dasoni (1/11/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:27 am
mahesh.dasoni (1/11/2013)
i have publisher & distributor on same server with pull subscription .
Thats INCORRECT .In PULL subscription, The Distribution Agent or the Merge Agent runs at the Subscriber.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:23 am
raghuldrag (1/10/2013)
(Note tax_code ED12%,cess 5% like it may variate for each po_no)here EDpecrntage may variate,depnds the variance ve to calculate values of taxez
Couple of question
1) what is the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:17 am
CELKO (1/10/2013)
Since a table is a set, your table is “Customers” -- unless you have only one (sorry business is bad). It is called Strong entity; it can exist by...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 1:06 am
arnipetursson (1/10/2013)
You have to remember that NULL in SQL means two things:1. Empty set
2. Undefined set.
This is an well know set algebra bug in SQL.
NO , NUll is not...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 12:55 am
see this link too http://blog.sqlauthority.com/2011/02/09/sql-server-pageiolatch_dt-pageiolatch_ex-pageiolatch_kp-pageiolatch_sh-pageiolatch_up-wait-type-day-9-of-28/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 12:48 am
PAGEIOLATCH_SH means slowness in IO operations. this is the one cent which will come to anyone's mind who will look into your posts.its might be happening because BIg tables invole...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 11, 2013 at 12:47 am
APA0876 (1/10/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 11:54 pm
ravi@sql (1/10/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 11:29 pm
Database admin(DBA) (1/10/2013)
so how to altered the query...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 10, 2013 at 1:29 am
Viewing 15 posts - 526 through 540 (of 2,462 total)