Forum Replies Created
Viewing 15 posts - 6,031 through 6,045 (of 7,499 total)
-
RE: Free Space
maybe this will help out ....
I don't have the ref where I got it
CREATE TABLE #tables_usage (
name varchar(50) NULL,
rows varchar(15)...
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: Partitioning Function,Sql Server 2005
here's a very good article ...
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: find databse size tsql
use yourdb
exec sp_helpfile
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: Managing Blocking in sQL 2000 ? Need a code to determine Deadlock
you may want to add following startup-parameters to your sqlserver so you get a glimp regarding deadlocks...
-T1204
-T3605
to activate this without stop/start :
--dynamisch activeren
dbcc traceon(1204, 3605, -1)
but add 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: DTS Designer Error
- also upgrade to sp4.
- what kind of connections did you allow for sqlserver
(sqlserver serverproperties network-config)
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: Mount points vs. drive letters....
...Not that I expect that anyone would run out of drive letters...
- consider a cluster-node with a couple of instances topology driv1-data1 drive2-data2 drive3-log drive4-backup .... You'll run out of...
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: ALTER TABLE, add column with IDENTITY
If you want the identities to start using your specific startvalue, you should specify it when adding the identity-column. Not afterward with a checkident !
Check books online !
regarding the reseed,...
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: ALTER TABLE, add column with IDENTITY
or direcly
ALTER TABLE UsersImport ADD userIdInt int IDENTITY (99,1)
or build the alter dymamic :
declare @stmt varchar(4000)
select @stmt="ALTER TABLE UsersImport ADD userIdInt int IDENTITY (" + convert(varchar(15),@yourvar) + ',1)"
exec (@stmt)
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: Moving a SQL Server 2000 machine to a new domain
No problem
SQLServer publishes itself !
If you don't change the servername, there is no problem.
IPaddress changeing is no problem, as long as your applications do not connect directly using the IPaddress...
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: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
...but existing objects could not make use of the secondary filegroup?...
- If you don't alter existing objects (tables or indexes), they will not use the new filegroup ! You have...
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: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
- and off course there should be space at disk-level
- your db already has a filegroup named 'secondary'
choose another name. contact 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
-
RE: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
- use xp_fixeddrives to check out your current freespace at the "local" drives.
(this proc may be secured)
- there may be file-latency when extending a datafile (from your primary filegroup)...
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: INSERT & UPDATE not working all of sudden
how about (b)locking issues, long running requests,...
sp_who2, sp_lock may help out
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: sp_detach_db works, re-attaching it doesn''''t!
in that case also copy the path to the ldf file from explorer.
maybe the best way is to rightclick and hold and drag to the run window
(start\run) clear 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: Single/Double quote in [A-MSG] token
with SET @Msg = 'Error: [A-ERR]' + CHAR(10) + 'Severity: [A-SEV]' + CHAR(10) + 'Date: [STRTDT]' + CHAR(10) + 'Time: [STRTTM]' + CHAR(10) + 'Database: [A-DBN]' + CHAR(10) + 'Message:
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,031 through 6,045 (of 7,499 total)