Viewing 15 posts - 4,711 through 4,725 (of 7,499 total)
try using this for the second test:
IF(@SFound = 1) SET @sql = @sql + 'ALTER TABLE [dbo].[ptNotes] ALTER COLUMN [Type] varchar(10) NULL;'
We've all had this kind of experience...
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
July 16, 2008 at 1:19 pm
I hope this is not on a production database system.
Don't shrink the db unless you realy need to !
SQLServer needed the log-space to support your db !
Making a log-backup frees...
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
July 16, 2008 at 1:04 pm
btw the HowTo for lock pages in memory:
See bol: "How to: Enable the Lock Pages in Memory Option (Windows)"
http://msdn2.microsoft.com/en-us/library/ms190730.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
July 15, 2008 at 5:16 am
One good starting point for MS might be to post the demo-applications and the related source-code.
As everybody knows, copy-paste is your best friend 😉
We've all seen the demo on db...
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
July 15, 2008 at 2:11 am
Perry Whittle (7/14/2008)
VM's under ESX 3.x can support 16GB RAM, 4 vCPU, 4 vNIC. ESX 3.x also allows you to use the full 8 node MSCS
That's an enhancement indeed. Thanks...
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
July 15, 2008 at 12:42 am
Tran_Key NOT IN ( SELECT Tran_Key
...
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
July 11, 2008 at 8:11 am
mailsar (7/10/2008)
.... "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" ...
Maybe you should first try to upgrade to SP2 including the latest cumulative update (CU8).
If the reinstall of SSMS doesn't help out ....
you may need to reinstall...
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
July 11, 2008 at 7:17 am
Ansi settings may indeed have an impact.
Also check the transaction isolation level.
(although IMO that shouldn't generate another exec plan)
Same query :crazy:
Are you sure the query is 100 % equal !
(included...
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
July 11, 2008 at 7:11 am
did you try to drop the full PK constraint ?
ALTER TABLE your_partitioned_table
DROP CONSTRAINT PK_ ... '_constraintname
You may not be able to drop the PK if you have foreign keys that...
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
July 11, 2008 at 5:17 am
IMO:
- a user cal is dedicated to a user ! ( may connect to any number of instances)
- a device cal is dediceated to a (client) device ! (may connect...
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
July 11, 2008 at 12:23 am
you can view the partitioned objects using these queries:
USE [DPartitioning]
/*
show partitioned objects
*/
select distinct
p.[object_id],
TbName = OBJECT_NAME(p.[object_id]),
index_name = i.[name],
...
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
July 9, 2008 at 2:08 pm
IMO you are turning your cat inside out.:ermm:
If you stick to this bad design, your queries will not perform well !!
resulting in slow applications and over utilised servers.
If you install...
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
July 9, 2008 at 6:31 am
be sure to include the objects schema ! (even if it is dbo)
don't use reserved words in your objects or always use brackets !
In your case it was object "user"...
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
July 9, 2008 at 5:47 am
Be sure to point to the correct filelocations !
(and they must be reachable for the sqlserver service account !!)
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
July 9, 2008 at 5:38 am
IMHO your clientidS column is a prove of bad design ! (one column containing a bunch of seperate dataitems)
Check out "normalization" at SSC.
You cannot execute a sproc in a...
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
July 9, 2008 at 5:36 am
Viewing 15 posts - 4,711 through 4,725 (of 7,499 total)