Viewing 15 posts - 1,711 through 1,725 (of 2,462 total)
Vladan (5/8/2010)
this is quite an interesting problem. I never had to do anything with such calculations, but I was interested how I would solve it and here is what...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 8, 2010 at 10:59 pm
GilaMonster (5/7/2010)
When the query(s) have no single optimal plan. One example is when you have severe parameter sniffing, data skew or similar.
how do we come to know this ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2010 at 8:05 am
sandhyarao49 (5/7/2010)
Will shrinking a log file will break the Logshipping process.
Any specific reason behind it ? i guess your log is rapidly growing.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2010 at 7:40 am
clucasi (5/7/2010)
what kind of time frame would we expect the query to take.
depends on various factors like
hardware config, network io, vol of data in tables ,indexes, how much query...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2010 at 5:40 am
Atif Sheikh (5/6/2010)
Why not to use Top(N) clause with Order by Col1?
again Indexes will matter here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2010 at 1:41 am
ColdCoffee (5/6/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 8:57 am
TheSQLGuru (5/6/2010)
That type of WHERE clause is HORRIBLE from a performance standpoint. Our own Gail Shaw has a very nice blog...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 8:40 am
Chinna-703814 (5/6/2010)
how do we set it for sql server 2005
and more important why we need to set it up ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 7:49 am
clucasi (5/6/2010)
i have checked the insert and update and they work on there own, and I have tried the case statement and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 4:12 am
refer this link
http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/
http://support.microsoft.com/kb/329204
http://technet.microsoft.com/en-us/library/ms181007(SQL.90).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 3:27 am
magasvs (5/5/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 12:06 am
Tara-1044200 (5/5/2010)
i miss this sql user for which i have to drop and re create.
whenever we restore backup , users automatically get transferred (obviously orphan users) . So how did...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 6, 2010 at 12:00 am
Something like this
select * from db1.dbo.table union all
select * from db2.dbo.table union all
select * from db3.dbo.table union all
select * from db4.dbo.table
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 8:57 am
kbnyny (5/4/2010)
2nd Question is how can I get all the results from the two db within the 4 columns without have both db table colums displayed.
Either you need to give...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 8:55 am
middletree (5/4/2010)
there's no record of any loginname/password, including sa. And yes, we did try sa and blank.
then how do you login now ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 8:01 am
Viewing 15 posts - 1,711 through 1,725 (of 2,462 total)