Forum Replies Created
Viewing 15 posts - 6,001 through 6,015 (of 7,499 total)
-
RE: Counting months???
check out datediff(mm, lowerdate, higherdate)
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: Worst Practice - Not Qualifying Objects With The Owner
yes.
prior to sql2005 sqlserver would search for ...
databaseName.YOURLOGINUSER.orders
then for databaseName.DBO.orders
with sql2005 it will start searching for ...
databaseName.YOURDEFAULTSCHEMA.orders
then for databaseName.DBO.orders
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 File
is this a backup file ?
If yes, maybe there is a backup-device pointing to it ...
exec sp_helpdevice
you can rerout it using
begin tran
exec sp_dropdevice @logicalname = 'yourdevicename'
exec sp_addumpdevice @devtype =...
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: scheduling SQL server to restart
if you are running a default instance of sqlserver :
from books online:
net stop mssqlserver
Stops an instance of SQL Server either remotely or locally if you are running the Microsoft...
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: Developers and DBAs
Seen it .... been there ..... done that .... burned out ..... revived ... bailed out ...
Now I'm having a job that's giving me the occasion to develop my...
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: scheduling SQL server to restart
Do you mind me posing the question why you would do something like that ???
If it is sqlserver consuming to much memory, 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: SQL 7 Can not truncate Transaction Log
maybe this will get you on track ...
INF: How to Shrink the SQL Server Transaction Log
http://www.support.microsoft.com/kb/256650
and yes, you may have to repeat this action a couple of times
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: Upsert Dimension Table
same player shoot again .... hit ball when lights are 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: Clearing up objects from cache selectively
Indeed, sometimes we tend to overlook the obvious
Look what I found in my archives ...
Select 'print '' proc to be recompiled : ' ...
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: take offline to download resources.
In stead of taking them offline, you may want to have a look at AUTO_CLOSE;
Alter database yourdb
Set AUTO_CLOSE ON / OFF;
This way, SQLserver closes the db when it is not...
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: Outlook 2003 with SQL Server 2000 doco
I don't have any doco to hyperlink to
We've switched to smtpmail because every once in a while the sp_sendmail got stuck and the...
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: Calling all Locking gurus
maybe http://sqldev.net/articles/wait_types.htm can get you on track to solve 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
-
RE: Waht is SQL Server Native Mode?
I'd suppose they are just trying to impress by finding out a new slang-word.
I guess what they are trying to find out is...
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: Outlook 2003 with SQL Server 2000 doco
- you'd probably be better of with using xp_smtpmail (http://www.sqldev.net)
- look for Configuring Mail Profiles in BOL.
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: Clearing up objects from cache selectively
- AFAIK clearing is a all or none operation.
- DON'T mess with systemtables !
Syscacheobjects isn't even a real table, but contains a systemstate.
- let sqlserver handle it's cache...
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,001 through 6,015 (of 7,499 total)