Viewing 15 posts - 1,501 through 1,515 (of 7,502 total)
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
Did you check Books Online (and especially its examples on the topic)
Recursive Queries Using Common Table Expressions
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:03 pm
FYI.
I noticed on my dev instance ( that was in a stopped stated during the apply of SP1CU4) that it only runs the upgrade scripts, not at install time, but...
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 12:58 pm
another very nice read on sqlserver statistics : SQL Server Statistics by Holger Schmeling
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 25, 2011 at 1:16 pm
marmarhm2002 (12/24/2011)
I want to access several DBs in my function. I execute this function on different servers so I've tried to
restrict access to specific DBs in each server with...
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 24, 2011 at 9:13 am
Viewing 15 posts - 1,501 through 1,515 (of 7,502 total)