Viewing 15 posts - 5,131 through 5,145 (of 7,499 total)
just a first glimps for a simple start
This select shows the values from within the same table...
Concept may be a good start..
select T1.[object_id], T1.[date], T1.data1 as T1_Data1, T1.data2 as T1_Data2
,...
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
March 5, 2008 at 5:09 am
Books online explains this very well !
The clustered index actually has the data in its leaf level !
A NCI is built aside from the table, based on the table 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
March 5, 2008 at 3:48 am
Adam Bean (3/4/2008)haha! That's my view!!! ...
This prooves once again the world is round :w00t:
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
March 5, 2008 at 3:27 am
actually your full sp might be replaced by one dts package.
If you don't need things to be synchronized online-realtime, switch to DTS !
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
March 5, 2008 at 3:08 am
there is a DMV exposing this in sql2005, I'll have to do a little search on it.
this comes from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2892190&SiteID=1
(I don't have my own scripts available for the moment)
-- CREATE...
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
March 4, 2008 at 12:48 pm
you can use DTS for this.
from EM in the table pane rightclick and select import/export data....
You can save the package and schedule it if needed.
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
March 4, 2008 at 12:47 pm
Don't swap schema.
Just create a
create view dbo.myview
as
select a.col1, b.col1, ...
from dbo.table1 a
inner join dbo.table2 b
on a.key = b.fk4a
- if you add with check it checks the results of...
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
March 4, 2008 at 12:40 pm
I knew your name did ring a bell 😀
the SSC-article http://www.sqlservercentral.com/articles/News/exceptionhandlinginsqlserver2005/2237/
introduces try-catch.
but I got to admit I like your art. more because it goes more in detail and has...
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
March 4, 2008 at 7:24 am
SQLserver only has a precision +-3ms
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
March 4, 2008 at 4:56 am
IMO if you'd enabled database owner chaining, things might have worked from the start on.
Post your clr-code and you have a good enough chance Jeff or someone else comes up...
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
March 4, 2008 at 4:55 am
there must be an art at SSC
but I found this one in my examples http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench
BEGIN TRY
SELECT CONVERT(INT, 'XYZ')
END TRY
BEGIN CATCH
-- ERROR_...
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
March 4, 2008 at 4:38 am
your sqlstatement is returing a resultset !
What are you trying to do ?
Why are you using dynamic sql to fulfill this 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
March 4, 2008 at 4:32 am
I'm not familiar with mysql :blush:
But hooking it op with sql2000 can be done using a linked server;
The code below works for msaccess
USE [master]
GO
-- EXEC master.dbo.sp_dropserver @server=N'LSTEST', @droplogins='droplogins'
EXEC master.dbo.sp_addlinkedserver...
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
March 4, 2008 at 2:29 am
Thank you for the excelent feedback, berto.
It's always nice to get test scripts and results of comparison..
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
March 4, 2008 at 1:10 am
one of the caveots is that your server gets dependent to another server.
This will make maintenance for the connected ones more difficult.
To be able to connect with mysql, you'll 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
March 4, 2008 at 1:03 am
Viewing 15 posts - 5,131 through 5,145 (of 7,499 total)