Viewing 15 posts - 4,441 through 4,455 (of 7,506 total)
You have added all files to FG1 !!!
FG2 does not exist !
--alter database AssignDB
--add file
--(
--Name=FG3_dat,
--FileName='C:\ClassAssign\FG3.ndf',
--Size=30MB,
--MaxSize=50MB,
--Filegrowth=5MB
--)
--to filegroup FG1;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 1:01 pm
Use:
- professional help ( SQLserver and shrink 😉 )
Both should be good
Some more info needed:
- OLTP / OLAP ?
- 15TB plus .... how many processors (cores ?),...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:15 pm
You cannot alter a UDT if it is used by objects.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:08 pm
do you mean
update yourtable
set yourcolumn = ''
where yourcolumn = 'NULL' -- column actually contains value NULL
or
update yourtable
set yourcolumn = ''
where yourcolumn is NULL -- column actually...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:01 pm
Yet another query 🙁
Maybe you'd be better off just copy/paste-ing the actual thing you want...
What is this selects giving you as a result:
Select count(*)
from myTable
where [CAR1] IS NOT...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 10:52 am
metalray (10/8/2008)
Issue solved,I just changed the order of columsn in my INSERT statement from
INSERT INTO dbo.myTable(Code,Amount, Car)
to
INSERT INTO dbo.myTable(Code,Car, Amount)
Hey, hey, ..... that's not what you posted first...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 8:04 am
metalray (10/8/2008)
I am down to one column that causes a problem. I have a simple INSERT:
INSERT INTO dbo.myTable(Code,Car, Amount)
SELECT
[AR] As [Code], --Year
[SDF] As Car , --Vendor
[SVB] As Amount...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 5:11 am
You have to open the needed port(s) clientside in the firewall.
HowTo ? That depends on the firewall software that is installed.
more info: http://support.microsoft.com/kb/287932
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 2:24 am
Since this is a clean install, I would upgrade to SP2 + CU9 or 10
and only then try debugging this
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 7, 2008 at 1:59 pm
Did you enable sqlserver for his firewall (client side) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 6, 2008 at 7:02 am
with db mirroring, every action on the primary database is sent to the mirror db.
It is not active, so no one else can tamper with it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 6, 2008 at 12:31 am
Keep in mind a backup file can contain more than one backup !
Are you creating log backups using the NOINIT parameter ? That's the way you can add a backup...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 5, 2008 at 3:15 am
check the ms website for more info and prereqs.
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
and
http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 4, 2008 at 12:36 am
That should be ok.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 3, 2008 at 11:54 am
Chris Morris (10/3/2008)
...but - without checking - it's probably expensive.
Yep, checking is what makes this job worth the while :hehe:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 3, 2008 at 10:52 am
Viewing 15 posts - 4,441 through 4,455 (of 7,506 total)