Viewing 15 posts - 1,501 through 1,515 (of 7,499 total)
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
Steve Jones - SSC Editor (12/19/2011)
PaulB-TheOneAndOnly (12/17/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 19, 2011 at 11:47 pm
sqldba_newbie (12/16/2011)
ALZDBA (12/16/2011)
Did 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 18, 2011 at 11:58 pm
actually the get-item cmdlet is one you'll use quite frequent.
The problem is to think of it, not only in file context, but in item context, whatever that item may be.
(filesystem,...
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 16, 2011 at 2:23 pm
Viewing 15 posts - 1,501 through 1,515 (of 7,499 total)