Forum Replies Created
Viewing 15 posts - 6,271 through 6,285 (of 7,502 total)
-
RE: Database Size (PSOFT)
Maybe this can help out generating your script :
-- I did change to not include Primary Keys !!
-- You'll have to drop/create the PK-constraints if you want 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
-
RE: Database Size (PSOFT)
How about statistics ? Do your have autostats enabled for your crm db ?
Every once in a while (3 or 4 /year) manualy perform dbcc updateusage and sp_updatestats. Depending on...
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
-
RE: Quickly Identify DEADLOCK information from TRACE data
Those traceflags will have SQLserver log deadlockinfo to the SQLServer ErrrorLog-files.
look at yourdrive:\MSSQL\LOG\ERRORLOG
or use EM / Management / Sql server logs
search for Deadlock
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
-
RE: creating a table in a specified file group
no.
btw 1) select top 1 * into yournewtable from yourquery
should be
1) select top 1 * into yournewtable from yourquery where 0=1
because you jus want to create the table without any...
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
-
RE: creating a table in a specified file group
- you could set your new filegroup to be the default filegroup. Remark : all new objects will then reside in that default filegroup, unless you reset it afterward.
- 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
-
RE: My query is just too slow - Please help
for this query alone, I would advise only a non-clustering (but covering) index since there is no extra data-access.
In general an " exists (select ... where correlated predicate = xxx)...
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
-
RE: My query is just too slow - Please help
IMO this notation is more comprehensive ...
Select * From Master
INNER JOIN Details D1
ON Master.MasterID = Details.MasterID
and D1.Value = 'Criteria1Value'
INNER JOIN Details D2
ON Master.MasterID = Details.MasterID
and D2.Value = 'Criteria2Value'
provide...
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
-
RE: about duplicate spid''''s ??
sqlserver version and sp / hotfix ?
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
-
RE: DOS Batch File which copies directories from one server to another server
I use this kind of instruction as a last step of my backup-jobs to copy to safehaven.
XCOPY C:\MSSQL\BACKUP\*.* \\myUNCservername\myshare\MyDbServerName\Database\ /c /k /h...
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
-
RE: about duplicate spid''''s ??
- duplicate spids are caused by parallelism.
- they shouldn't interfere with backup activities
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
-
RE: Geocoding with SQL Server 2005
It works just fine now !!
Imports
System
Imports
System.Data
Imports
System.Data.SqlClient
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
-
RE: Geocoding with SQL Server 2005
Thank you for your time.
It took me a while, but finaly I got the winform app to work ...
Address = Address.Replace(
" ", "+"
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
-
RE: Geocoding with SQL Server 2005
Here it is ... my vbform :
form fields : streettxt , citytxt, statetxt , datagridview Resultsdgv
form button : CallWebServicebtn
here's the code :
Imports
System
Imports
System.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
-
RE: Geocoding with SQL Server 2005
I like the article and the example.
I've tried to install it on my local sql2005STD instance wich has clr enabled and my testdb is trustworthy.
The vb.net version as well 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
-
RE: SQL2000 slow response
about the same goes for "Spotlight on SQLServer" from Quest software.
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
Viewing 15 posts - 6,271 through 6,285 (of 7,502 total)