Viewing 15 posts - 4,216 through 4,230 (of 7,506 total)
We told you partitioning was a advanced topic.
You must read the mentioned white papers to get the actual details why and when you need to include the partitioning column !
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
December 31, 2008 at 6:18 am
Hooman Shamsborhan (12/30/2008)
[font="Verdana"]...
--This is the part that causes problem
ALTER TABLE [dbo].[Transaction_Summary_2] ADD CONSTRAINT [PK_Transaction_Summary_2] PRIMARY KEY CLUSTERED
(
[Transaction_Serial_No] ASC
) ON [Data5] --ON TranactionSummary_Schema(Channel)
--to here
....
[/font]
If you create all indexes without...
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
December 30, 2008 at 5:34 am
and you did shut it down by hitting ctrl+C in the cmdbox where you started it.
2008-12-28 20:37:46.09 spid7s SQL Server shutdown due to Ctrl-C or...
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
December 29, 2008 at 3:31 am
GilaMonster (12/28/2008)
ALZDBA (12/28/2008)
Try to export the data without these column, so you only lose the text/image stuff if...
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
December 28, 2008 at 1:41 pm
it has troubles opening your AdventureWorks2008 database.
check your errorlog for e.g.:
2008-12-27 12:03:02.56 spid41s Starting up database 'AdventureWorks2008'.
I would try to get it back up and running...
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
December 28, 2008 at 1:33 pm
I'll see what I can do ...
I'm not that the office until Jan 5th ...
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
December 28, 2008 at 9:16 am
- Did you follow best practices by taking a backup before you moved the datafiles ??
- if you did perform a clean shutdown and there weren't any ongoing transactions, you...
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
December 28, 2008 at 9:02 am
- you should check "c:\program files\microsoft sqlserver 2005\"
there should be a mssql.1 folder, that one contains a file called "errorlog" if you post its content, we may be able to...
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
December 28, 2008 at 8:54 am
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005:
- http://msdn.microsoft.com/en-us/library/ms143799(SQL.90).aspx
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
December 28, 2008 at 8:47 am
also keep in mind you need to enable TCP/IP on your sqlserver instance (server configuration manager) and restart the sqlinstance for it to be able to allow connections over tcp/ip
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
December 28, 2008 at 8:43 am
even better, BOL now contains more info on DBCC statements then ever !
No yet for all, but for the most of them you'll ever use.
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
December 28, 2008 at 8:40 am
no doubt about it, you should fix the db in sql2000 !
btw: what service pack are you on (sql2K) ?
Keep a copy of the backup of the corrupted database !...
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
December 28, 2008 at 8:35 am
it may not only be the left join, but I guess most of the waste time will be the correlated join predicate !
apparently this can be an indexed item, but...
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
December 24, 2008 at 6:09 am
Well, the instance didn't failover, but it dumped like hell.
SQLErrorlog file stating ".... a lock it does not own .... " which IMO is a symptom for the lock manager...
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
December 24, 2008 at 4:32 am
bodhilove (12/23/2008)
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
December 24, 2008 at 4:15 am
Viewing 15 posts - 4,216 through 4,230 (of 7,506 total)