Viewing 15 posts - 5,521 through 5,535 (of 7,502 total)
- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx
CREATE view [V_partitioned_objects]
as
select distinct
p.[object_id],
index_name = i.[name],
index_type_desc = i.type_desc,
partition_scheme = ps.[name],
data_space_id = ps.data_space_id,
...
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
October 23, 2007 at 7:54 am
- I think you should post in sql2005 (sys.sysusers)
- be carefull with users being actual dbowner !
- be carefull with users owning objects in databases
- Indeed you need to handle...
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
October 23, 2007 at 7:53 am
With SQL2005 you can use server ddl triggers to detect / intercept those kind of actions.
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
October 23, 2007 at 4:43 am
1) if you still have the builtin/administrators local windows group in your sqlserver's logins list, one can become sqlserver sysadmin by being added to the windows local administrators group.
2) I...
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
October 23, 2007 at 12:50 am
hehe, nice to see that the code html-tag does its work in the forums.:w00t:
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
October 23, 2007 at 12:17 am
This is the query I start with: 🙂
SELECT dmv_cntr.[object_name]
, dmv_cntr.counter_name
, dmv_cntr.instance_name
, dmv_cntr.cntr_value
, dmv_cntr.cntr_type
, CASE dmv_cntr.cntr_type
WHEN 537003264 -- This counter is expressed as a ratio and requires calculation. (Sql2005)
THEN CONVERT(FLOAT,dmv_cntr.cntr_value) /coalesce(RatioBaseValue.cntr_RatioBaseValue,-1)
ELSE...
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
October 23, 2007 at 12:12 am
Did you have a look at SQLH2 ?
- http://www.sqlservercentral.com/Authors/Articles/Kathi_Kellenberger/43147/
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
October 22, 2007 at 12:13 am
- Indeed performance_dashboard is a great resource.
- http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424 has more info regarding the pct calculation.
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
October 22, 2007 at 12:11 am
select cast(yourcolumn as char(10)) as yourchar10
from ...
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
October 19, 2007 at 10:34 am
Their data can be in a single table.
Provide a view for each of them, but create the view "WITH CHECK OPTION", so they can only modify data that fits into...
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
October 19, 2007 at 10:30 am
- first of all start with making a full database backup
- you state it only contains 4Mb of actual data.... How long is it in use ?
- how much...
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
October 19, 2007 at 10:25 am
for the SSCM (config manager) you'd have to connect to the physical box on which sqlsever is installed. (authority ?)
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
October 19, 2007 at 8:02 am
You could use :
- start\run Services.msc and start your sqlsever service overthere.
- Or use the SQL Server Configuration Manager, but I don't know it that accompanies SQLExpress. :blush:
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
October 19, 2007 at 7:20 am
check the MDAC level of the devices that are not able to connect to your named instance. It should be at least MDAC2.6 at client level.
btw you can download it...
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
October 19, 2007 at 7:09 am
you have to take care : SQLserver may want to try to overwrite the original files at the original locations if you work on the same box. !
I must say...
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
October 19, 2007 at 7:04 am
Viewing 15 posts - 5,521 through 5,535 (of 7,502 total)