Forum Replies Created
Viewing 15 posts - 6,271 through 6,285 (of 7,499 total)
-
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
-
RE: help with select statement
First of all, you query is to heavy !
You use 3 objects and only join two of them, leaving the 3-th one for crossjoining ???
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
First I would start looking in the Windows event log searching for IO-errors (cards or disks) if you can perform a checkdisk,..
Then check if there are memory errors.
Then perform dbcc...
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: help with select statement
indeed F1 just brings up BOL,
shift-F1 brings up BOL and positiones to the selected statement in possible.
e.g. create index x on mytable (y)
when you select "create index" and then...
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,499 total)