Viewing 15 posts - 1,441 through 1,455 (of 7,502 total)
Have a look how Grant summarizes it all:
http://www.sqlservercentral.com/Forums/FindPost684939.aspx
and here's another forum thread where I summed up my guidelines ( ... see how things match 😉 )
http://www.sqlservercentral.com/Forums/FindPost1033453.aspx
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
February 18, 2012 at 6:32 am
This may not be the most optimal solution, but it may be a start ...
for ($i = 0; $i -lt $data.Length; $i += 4){
$name = $($data[$i] -split 'Found file ')[1]
$group...
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
February 17, 2012 at 1:07 pm
It depends.
A drop table removes the object from the database. (including indexes, grants, ...)
What would be the difference of using a temp table ?
A truncate only removes...
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
February 17, 2012 at 12:04 pm
Sorry for that.
Apparently I posted the wrong version.
Constraints should be using 'with check' for the obvious reasons.
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
February 16, 2012 at 7:27 am
maybe this attached sproc can get you started.
its goal is to generate a sequence of drop fk, convert pk 2 clustered, create fk encapsulated into a transaction per pk.
Actual...
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
February 15, 2012 at 1:40 pm
that would be to much if it isn't needed for that user to actually read the data.
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
February 15, 2012 at 1:26 pm
Shouldn't the login have been granted dbaccess any way ?
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
February 15, 2012 at 11:15 am
Why would you always want your primary key to be clustered ??
You should first check if your table has a clustering index.
I would also pay attention to the composition...
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
February 15, 2012 at 3:05 am
Did you have a look at the sqlserver Errorlog files ?
You can use SSMS to do so or import them and query on using sp_sys.sp_readerrorlog
If you are defining "failover" as...
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
February 15, 2012 at 2:59 am
-Please post your target table DDL ( including constraints and indexes )
did you try this ?
INSERT INTO dbo.VRWATSYSTABLE
SELECT distinct *
FROM [ZAVRCICAHS1].[Environmental].[dbo].[EnviroTable] Src
where not exists ( select 1 from dbo.VRWATSYSTABLE Trg...
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
February 15, 2012 at 2:42 am
Dev (2/7/2012)
Sorry to disagree with you Johan... It looks like 5GB database.~5Gb data, with new tables created daily, and updates across around a dozen tables each day.
I just...
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
February 7, 2012 at 11:56 am
Perry Whittle (2/7/2012)
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
February 7, 2012 at 8:21 am
This is how we check if the db is available:
if exists ( select 1
from sys.database_mirroring
Where ...
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
February 7, 2012 at 12:01 am
So you implemented partitioning to overcome a rebuild problem.
Did you align indexes ?
If not, you end up practically in the same situation with regards to rebuilds.
If you did align...
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
February 6, 2012 at 11:31 am
- are you monitoring dbmirroring events ? If not, you should implement that ! (see attachments )
Your default trace file(s) may also help you to diagnose this issue !
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
February 6, 2012 at 11:09 am
Viewing 15 posts - 1,441 through 1,455 (of 7,502 total)