Viewing 15 posts - 5,296 through 5,310 (of 7,499 total)
2. Resorting tnx log back (t2)
>>> restore log t1 from disk = 'd:\t1.bak' with file = 3, norecovery (tnx backup)
Processed 1 pages for database 't1', file 'T1_Log' on file 3.
RESTORE...
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
January 23, 2008 at 2:59 am
can you set the dblevel to 90 (SQL2005)
Some functions do not work with dblevel 80.
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
January 23, 2008 at 2:36 am
if you use
alter table xyz add mycol int not null default 0
keep in mind to rebuild your indexes afterward because your clusterratio may be horrible !
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
January 23, 2008 at 12:33 am
- search for 'pivot' in the forums at SSC, you'll find some examples.
- you'll need to build your query with sql2000
something linke
select group1, group2,
, sum(case when detailcolumn = 1 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
January 23, 2008 at 12:28 am
I haven't tested that, but if you have all your log-backups, IMO it should be possible.
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
January 23, 2008 at 12:24 am
- Are your trying to connect to a sqlexpress instance ??
- can you post
select @@version
-- or the
select serverproperty('Edition')
, serverproperty('productlevel')
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
January 22, 2008 at 11:31 pm
select serverproperty('productlevel')
check 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
January 22, 2008 at 11:24 pm
pivot does not exist in SQL2000
You've posted in the wrong forum.
Dynamic sql is your alternative.
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
January 22, 2008 at 11:22 pm
my addition....
Indeed, for plan reuse, the line is getting very thin.
regarding security, the gap has not been closed.
- "curse and blessings of dynamic sql" is still valid; I haven't got...
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
January 22, 2008 at 1:14 pm
...application retrieves database info...
does your application accept client settings ? Check your client's settings for decimal point. If that is set to comma, it's an application flaw. The application...
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
January 22, 2008 at 1:10 pm
I assume your dts package (dts2000 ?) is trying to send a mail, but it does not succeed. Hence "NOTE: Failed to notify 'HELPDESK' via email."
Check your account that serves...
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
January 22, 2008 at 1:07 pm
can I have a go ?
Since I try to avoid hints ...
how about ....
-- just a copy from your initial #empshifts
insert #empshifts2
select * from #empshifts ;
--now set up...
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
January 22, 2008 at 12:43 am
with SQL2005 osql and isql have been replaced with SQLCMD.
If you cannot alter the software to use SQLCMD, I guess you'll need an SQL2000 client install (or msde) to get...
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
January 21, 2008 at 2:27 pm
- as with many of us, one of the problems is there is no application name '.Net SqlClient Data':crazy: provided by the connections.
- try to determine the host your suspect...
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
January 21, 2008 at 6:14 am
can you post the result of "sp_who2" (standard system sproc ) ?
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
January 21, 2008 at 5:14 am
Viewing 15 posts - 5,296 through 5,310 (of 7,499 total)