Viewing 15 posts - 4,051 through 4,065 (of 7,496 total)
Actually it deffers very silghtly because the db will need to be put offline to move the file !
The alter db is better because it keeps all dbinfo in master...
February 9, 2009 at 12:06 am
check out the new sql2005 keyword Except !
could be something like this...
update Ta
set colx = Tb.colx
...
from ( select * from table1
except
select T2.* from table2 T2
--...
February 8, 2009 at 10:51 am
8060 is still the limit for fixed size columns in a row.
Which version of SQL2005 are you on ?
Select @@version
Can you post the original table ddl ?
February 8, 2009 at 10:43 am
Indeed,Ahmad Osama, that is the best way (especially because downtime is not an issue) !
(I was just reflecting on that this morning, you know how that goes 😉 )
Or use...
February 8, 2009 at 12:54 am
dbv147 (2/6/2009)
I need to move an index file to another drive and thought I'd get some advice on the best way to do this. The index is on an archive...
February 7, 2009 at 8:20 am
It may be fixes with the latest SP. (sp3)
Can you post sqlserver version info ?
Select @@version
February 7, 2009 at 8:15 am
On the other hand, if someone has been granted access using windows authentication, it is not mandatory for that person to use the designated software to access the data.
Meaning: if...
February 7, 2009 at 8:11 am
0x80004005 usually means "not authorized"
- What's the service account of sqlagent?
- which account is owner of the job ?
- which is the proxy account used in the job ?
- How...
February 7, 2009 at 3:49 am
First notice:
[Customer_Business_Subset] starts with a full table scan in stead of an index seek !
([CMS3000_Reports].[dbo].[Customer_Business_Subset].[PK_Customer_Business_Subset])
152802 rows of 49bytes are expected
It wants so resolve [date_deleted] is null
It may be...
February 6, 2009 at 1:06 am
This is a SQL2005 forum .... you had better posted this Q in the SQL2000 one.
1) Check books online regarding filegroups and their behavior.
2) If you have control over to...
February 6, 2009 at 12:44 am
You can do it ... but should you ???
http://www.sqlservercentral.com/Forums/Topic639157-360-1.aspx
February 6, 2009 at 12:38 am
Thank you Max for the very informative refs.
More reasons for our devs _not_ to do decent db design 😉
February 6, 2009 at 12:12 am
Issues with linked servers can be:
- locking at linked server side
- network
- how and where does sqlserver solve the query to be executed at the linked server (full at linked...
February 5, 2009 at 7:47 am
scott_lotus (2/3/2009)
February 3, 2009 at 5:24 am
Oh, you're way behind with service packs :crazy:
You are running the RTM software level.
The url I provided concerns your software level.
SP3 is current and on our servers it runs just...
February 3, 2009 at 4:50 am
Viewing 15 posts - 4,051 through 4,065 (of 7,496 total)