Viewing 15 posts - 4,591 through 4,605 (of 7,506 total)
check for SQLServer Migration Assistant for Oracle.
(there is a sql2005 and a sql2008 version)
free download at http://www.microsoft.com/downloads/details.aspx?familyid=6D9BC6A7-75DA-493E-BEE5-50F4A4352B91&displaylang=en
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
September 7, 2008 at 5:51 am
just my 2 ct
Max Mulawa (9/4/2008)
Does 'SQL Server Browser' service is running on your remote server?
You can connect using the actual instance port number, so my guess would be 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
September 7, 2008 at 3:49 am
Why would you want to use a function if you can do a join ?????
Most of the time it's these kind of functions that mess up response times in your...
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
September 7, 2008 at 3:47 am
Maybe this one can help you:
CREATE PROC spc_ALZDBA_check_failed_jobs
@NumDays int = 1,
@RecentOnly char(1) = 'n',
@Job_Name varchar(132) = Null
AS
begin
-- example: sp_ALZDBA_check_failed_jobs 5,...
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
September 7, 2008 at 3:41 am
I think you can create a snapshot database, and make a backup of that.
TEST IT - TEST IT
/* Database Snapshots */
CREATE DATABASE Adventureworks_ss1430
ON (NAME = AdventureWorks_Data,
FILENAME = 'C:\Backups\AdventureWorks_data_1430.ss')
AS SNAPSHOT...
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
September 7, 2008 at 3:25 am
you may want to read Jeff Modens "Tally table" article.
In sql2005 you can use ranking functions. 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
September 7, 2008 at 3:21 am
If you have heavy disk activity, it may be your extending tempdb-process that gets a timeout, resulting in the errormessage you've seen.
As already stated, tempdb is one of the working...
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
September 7, 2008 at 3:20 am
For the moment we are using vbscript to gather WMI information.
You may as well put that into a clr module and get your info that way.
Keep in mind you'll need...
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
September 7, 2008 at 3:12 am
X64 is not Itanium, but is 64 bit.
64-bit can directly address way more than 16Gb http://techreport.com/articles.x/8131/2 or http://en.wikipedia.org/wiki/X86-64
Thats why you don't need to enable AWE anymore on 64-bit.
You need 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
September 7, 2008 at 2:57 am
you could deny a user access to a table using:
DENY { ALL [ PRIVILEGES ] }
| permission [ ( column [ ,...n ] )...
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
September 6, 2008 at 11:31 am
There are articles at SSC regarding db ownership.
e.g. http://www.sqlservercentral.com/articles/Advanced/understandingobjectownership/1966/
We don't use sa for login, but have all databases owned by sa.
All sysadmin stuff is being performed using our windows-admin-accounts. (dbas...
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
September 6, 2008 at 11:28 am
You could offer the dba a weeping tissue because he's the one messing up. They will have to modify their code.
As already stated : If you want order, you need...
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
September 6, 2008 at 11:20 am
MS has released a Upgrade assistant for Access.
(free tool)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
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
September 6, 2008 at 7:20 am
Warren Peace (9/5/2008)
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
September 5, 2008 at 12:40 pm
As usual, security has been optimized in sql2005 !
For a proc to work in a database context, it needs to be in that database,
except for procs (residing in master...
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
September 5, 2008 at 12:34 pm
Viewing 15 posts - 4,591 through 4,605 (of 7,506 total)