Viewing 15 posts - 9,736 through 9,750 (of 18,926 total)
Check out the Microsoft site for more info, I don't have a link available (maybe someone else will).
The simple fact is that if it worked with 2000, it'll work with...
June 26, 2007 at 2:52 pm
Check out the functions UPPER, LOWER, LEFT, RIGHT, and Substring to solve this problem.
June 26, 2007 at 2:36 pm
You lose the chance to use the new 2005 features. That's about it.
I'm sure there are a few more gotchas than this, but I would not expect a lot (this...
June 26, 2007 at 2:34 pm
Never done anything like this before so I'm just throwing ideas out there.
- BCP IN
- Linked server to text file
- Make a small app (vba, vbs) that inserts line by...
June 26, 2007 at 2:03 pm
Never seen that before. Sorry if I can't be of more help at the moment.
June 26, 2007 at 12:04 pm
Best way I know to get performance out of this (assuming that the scans are unacceptable for you), is to create 2 different queries, optimize them separatly, then run them...
June 26, 2007 at 11:26 am
1) Make sure that system catalogs updates are off?
2) Is she creating the tables as dbo.tblname or only create table tblname ...?
I'd make sure she uses the dbo keyword.
Other than that,...
June 26, 2007 at 11:17 am
Thanks for the reply... I knew I had seen this somewhere a while back, now I can sleep better
.
June 26, 2007 at 11:06 am
Am I dreaming this, or did visa cards have some cards with 12 numbers on it at some time in the last 10-15 years?
June 26, 2007 at 7:48 am
Thanks for the tip, this may avoid some small gotchas that can make you go mad. The object is a very nice touch on this one.
June 25, 2007 at 1:30 pm
Can you take the time to describe the procedure you used and the scripts required to do this? This will surely help someone else in the future who has the...
June 25, 2007 at 10:30 am
This should get you started :
SELECT I.Name AS IndexName, OBJECT_NAME(id) AS TableName, INDEXPROPERTY(I.id, I.Name, 'IsClustered') AS IndexIsClustered, FG.GroupName from dbo.sysfilegroups FG INNER JOIN dbo.SysIndexes I ON I.GroupID = FG.GroupID...
June 25, 2007 at 6:34 am
Exactly, assuming that the clustered index is different from the PK or the said unique constraint.
June 25, 2007 at 6:02 am
The data will remain where the clustered index is. Just make sure you don't move this index.
June 25, 2007 at 5:55 am
You mean that the full backup file is smaller than the previous day from time to time?
One likely cause is that you have less data than the previous day or...
June 24, 2007 at 7:14 am
Viewing 15 posts - 9,736 through 9,750 (of 18,926 total)