Forum Replies Created
Viewing 15 posts - 6,286 through 6,300 (of 7,499 total)
-
RE: help with select statement
Books Online is a valuable resource. It contains the help for SQL and SQLServer
From Query Analyser, you can access it pressing Shift +...
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
how about
select substring(account_number,1,2) as Acc_prefix, count(*) as Counter
from your_accounting_table
group by substring(account_number,1,2)
order by Acc_prefix
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: Best Practices, Read-Only Query Tool
Yelena's method is straight forward and manageble.
Just keep in mind you'll have to rebind the views when altering database object in your base-db.
I'd...
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: New job next week, need to healthcheck databases - how??
- collect sqlserver version info.
- use sp_helpdb to get a first impression of the db-settings that are in use.
- perform sp_updatestats / dbcc updateusage for all db that use "autoupdate...
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: How to reclaim Unused table Space as db Feespace?
do all tables have a clustering index ?
I guess not. So for this maintenance time, you may want to create one (for each table ! ). If you just pick...
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: Table Fragmentation
Check out : http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp
search SSC for "fragmentation"
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: Troubleshooting SQL Server with the Sysperfinfo Table
It was the featured article in the daily newsletter of 2006/04/21.
That's why I tought I just might add a path towards sql2005
Anyway, nice...
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 Sever 2005 SP1
looking good overhere.
Only thing is to plan the reboot ! (who wouldn't )
It is a "strange" thing that it does not recognize it's own need for reboot (sql native client...
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: Convert and MAX Function
I'm not that much into reporting server, but you can also have this solved in your select query
SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth
, CONVERT(char(11), dateadd(mm,-1, MAX(src_date)))...
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: Convert and MAX Function
converting to soon.
SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth
FROM tbl_src_date
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: Troubleshooting SQL Server with the Sysperfinfo Table
FYI
in SQL2005 you have DMV's (e.g. sys.dm_os_memory_clerks) to followup this kind of info.
e.g. clr-info : http://blogs.msdn.com/sqlclr/archive/2006/03/24/560154.aspx
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: Shrinking the database file
-- this one works on SQL7 and SQL2000
You may have to run this script a number of times, because of the reasons I mentioned in previous the post.
-- Shrink_TrxLog.SQL
--INF: How 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
-
RE: SQL Server 2005 - Changing Port in Cluster Environment
thanks for the feedback.
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 Server 2005 - Changing Port in Cluster Environment
I have altered the IPAll port, and even enabled the instance's own ipaddress with another port, but connecting using the latter ipaddress/port did not work !
Connecting using the ipaddress/"IPAll-port" worked...
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 Server 2005 - Changing Port in Cluster Environment
altering the IPAll port, will have only that port active for connections when working with fixed ports.
(just done a quick test)
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,286 through 6,300 (of 7,499 total)