Viewing 15 posts - 4,711 through 4,725 (of 7,496 total)
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...
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...
July 15, 2008 at 12:42 am
Tran_Key NOT IN ( SELECT Tran_Key
...
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...
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...
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...
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...
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],
...
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...
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"...
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 !!)
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...
July 9, 2008 at 5:36 am
just to add to Gails reply..
be sure to provide indexes that match your FK-declaration !
(because otherwise you 'll end up with dependant table scans !!)
July 9, 2008 at 5:27 am
It's been a while, but I've seen a solution for mainframe db2 where you could prepare a full set of (related) data to be loaded into an environment.
I cannot...
July 8, 2008 at 12:01 am
just a little remark:
avoid using left and right outer joins together.
Choose one and go with that. (I prefer left join because then you're result is formed from top to...
July 5, 2008 at 6:24 am
Viewing 15 posts - 4,711 through 4,725 (of 7,496 total)