Viewing 15 posts - 3,781 through 3,795 (of 7,499 total)
You need to add the date column to your time column or you will end up with negative times
Work with datetime datatype so at the end you just need...
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
April 16, 2009 at 12:37 am
klnsuddu (4/15/2009)
thanks,No need to run the update statistics job for ever or can we run weekly?
With sql2000 I used to run sp_updatestats and dbcc updateusage (0) with count_rows after the...
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
April 16, 2009 at 12:28 am
There will be an overhead when deleting rows, and because the dependant table will be empty, that overhead will be minimal.
But If you have control to that process, you could...
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
April 16, 2009 at 12:16 am
JacekO (4/15/2009)
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
April 16, 2009 at 12:06 am
An other alternative to Gregs proposal:
(Only a referenced table cannot be truncated without first removing the relationship.)
from BOL: "Truncate table"
You cannot use TRUNCATE TABLE on tables that:
- Are referenced...
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
April 15, 2009 at 1:34 pm
As I learned from Gail Shaw, the issue of outdated statistics with sql2000 caused by the way your data is added/deleted/updated shouldn't be an issue with sql2005 anymore. Its statistics...
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
April 15, 2009 at 1:16 pm
from bol:
Temporary Tables
You can create local and global temporary tables. Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions. Temporary...
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
April 15, 2009 at 1:06 pm
Aparently The BusinessEntity table is an implementation of a SuperType table.
Tables Person, Store and Vendor are Subtypes
As is with that implementation, BusinessEntity only provides a means of unique key for...
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
April 15, 2009 at 7:16 am
Can you add SP1 ? support.microsoft.com/kb/968369
BTW. your version numbers are incorrect !
They don't publish like 10.00.***
but the results I get are like 10.0.*** (SP1)
(with both
SELECT SERVERPROPERTY('productversion')
select @@VERSION
)
And...
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
April 15, 2009 at 5:14 am
You are correct.
Apparently MS is also promoting the .Net infrastructure to achieve optimal integration.
If you are developing a new application it is recommended that you consider using ADO.NET and the...
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
April 15, 2009 at 3:42 am
Tasumy (4/15/2009)
Ok thanks.In conclusion :
- for managing sqlserver : SMO
- for query : ADO.Net with .NET Framework Data Provider for SQL Server
Use SQLNCLI as much as 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
April 15, 2009 at 3:03 am
Technically that isn't a problem.
However, symantically that doesn't make sence to me.
If the BusinessentityID is non nullable, you must first assing the person to an existing business entitiy ?
If BusinessentityID...
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
April 15, 2009 at 2:56 am
XML columns start "in row" ...
My little test: ( never mind the xml content 😉 )
-- my test database
Create database SSC_Test
go
use SSC_Test
go
Create table T_SSC (
...
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
April 15, 2009 at 2:38 am
- Is you sqlserver instance enabled for tcp/ip connections ?
- is there a firewall active ? (you may need to open some ports)
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
April 15, 2009 at 2:13 am
manohar (4/14/2009)
QuestionID BIGINT (Primary key)
QuestionXML NTEXT
Will it be a problem if the datatype is NTEXT...
And also we wil store XML...
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
April 15, 2009 at 2:09 am
Viewing 15 posts - 3,781 through 3,795 (of 7,499 total)