Viewing 15 posts - 1,501 through 1,515 (of 7,506 total)
Keep in mind my comments are not that devs are by definition not suited to handle sqlserver stuff !
I know devs who do their stuff very well with regards 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
January 2, 2012 at 10:23 am
It depends of the experience of your dev teams with regards to :
- data analysis
- data documentation ( especially uniformity of data declaration )
- normalization process
- dealing with large...
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
January 2, 2012 at 12:57 am
did you look at the scripting of SSMS ?
or
have a look that the information_schema views ...
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA = 'Person'
order by TABLE_NAME, ORDINAL_POSITION ;
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
January 2, 2012 at 12:48 am
Whatever you do, make it an Inline Table Valued function !!!!!!!
( and use it with cross apply )
That is, if you would like it to perform.
Test it, test 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 30, 2011 at 1:53 pm
pkrudysz (12/29/2011)
ALZDBA (12/29/2011)
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- Cool.
ALZDBA (12/29/2011)
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, 2011 at 7:53 am
e.g.
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- granting auth at windows level ( e.g. to push backup files to a safe...
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, 2011 at 12:50 am
toddasd (12/28/2011)
Dev (12/28/2011)
george sibbald (12/27/2011)
logicinside22 (12/27/2011)
thanks folks for nice reply . I did with Detach and Attach Option and it looks good now.
can I then recommend that 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 29, 2011 at 12:01 am
please also double check guidelines of the software using your sqldb.
In some cases your software may be out of support when modifying physical stuff. :sick:
Did you check their performance blog...
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, 2011 at 1:11 am
have a look at Moving Database Files Detach/Attach or ALTER DATABASE?[/url]
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 27, 2011 at 11:54 am
suhailquadri (12/27/2011)
-- Statement that executes the CTE
SELECT Emp.*
...
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 27, 2011 at 7:35 am
indraneelandhavarapu-866099 (12/27/2011)
I just have to pass the parameters and union all those...
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 27, 2011 at 7:22 am
some interesting linked server refs:
http://www.sql-server-performance.com/2007/linked-server/
http://www.sqlusa.com/articles2005/linkedserver/
http://searchsqlserver.techtarget.com/tip/Tricks-to-increase-SQL-Server-query-performance
http://www.sqlservercentral.com/articles/Linked+Server/62246/
http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/
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 27, 2011 at 2:47 am
maybe actual hierarchyid datatype can serve you better with this quest, but here's a shot using a cte:
;
WITH cteOrgHierarchy
AS (
-- Anchor member definition
...
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 27, 2011 at 2:35 am
marmarhm2002 (12/26/2011)
I'm receiving the following error:
Invalid use of side-effecting or time-dependent operator in 'CREATE SYNONYM' within 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
December 26, 2011 at 11:48 pm
Even tough I don't like what you're about to do.
( only using it for linked server purposes, which is IMHO not the most optimal way to use sqlserver at all...
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 26, 2011 at 1:19 pm
Viewing 15 posts - 1,501 through 1,515 (of 7,506 total)