Forum Replies Created
Viewing 15 posts - 6,976 through 6,990 (of 7,502 total)
-
RE: Need help with deleting rows & table contraints
Put indexes on the FK-columns of your dependant tables (if multi-column, provide exact order and sorting !). (1 index per FK !)
If you have cascading deletes enabled, you can delete...
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: 2nd instance of an active\active cluster Fails to allocate min memory
- 1) the sum of both "Min server memory" ( 5092 *2 ) > (8Gb - 1 Gb)
(the -1Gb is the space for the OS to run and manage 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: GROUP BY vs DISTINCT -- SQL SERVER BUG ?
Multiprocessor box ? try adding with MAXDOP = 1 (ckeck BOL)
(there is an issue with count(*) with sql2ksp3a)
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: The Case for SQL Logins - Part 1
As always the straight way has some curves.
Indeed, ms-office / vbs / ... are often not taken into account when considering security.
IMO...
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: GROUP BY vs DISTINCT -- SQL SERVER BUG ?
The advantage of using group-by is that it can use an index if available and suitable.
distinct is done by adding a sort-step before...
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: GROUP BY vs DISTINCT -- SQL SERVER BUG ?
- Which sqlserver version is this being run on ?
- Can you post ddl with some data ?
- Can you post some (small) "correct" and "false" result sets ?
- Does...
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: Automating "Script Database"
take a look at :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508
"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdatabase /I /F c:\yourfile
rem SCPTXFR /? - Command line help.
rem...
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: IS_Member Always returns dbo and not membership of a role
What's the goal of your function ?
- returning the "highest" membership ?
- returning the "last in sequence" membership ?
(your current function)
- returning the "first in sequence" membership ?
maybe...
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: Security: Is there a way to lock down SQL Server Agent ??
is the xp_cmdshell still open ?
exec xp_cmdshell 'net stop sqlagent' might be your weak spot.
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 fix "Divide by zero error" in SQL Server
Like Derrick Leggett mentioned, figure it out !
If your investigation points the symantics are OK, then you might use a case statement .
declare @col1 ...
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: DBCC INDEXDEFRAG and UPDATE STATISTICS
- do you have autoupdate-stats on (at db level) ? just run it once in a while.
We just run it once in a while (4 times a year) because autoupdatestats...
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: @@Identity returning Null
As you did find out, @@identity <> primary-key-info
afaik there is no way to have the "just inserted" primary key info returned, unless you write a query,... This however is...
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: Linked Server to DB2 using IBMs OLEDB Provider (IBMDADB2)
I haven't used that combination yet.
We only use linked servers to non-sqlserver for problem solving. Only then the definitions are added and removed asap.
This is because we don't want...
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: @@Identity returning Null
Don't store concatenated stuff. It's not as adaptable as you might think.
Composite keys, don't have that huge downside.
If you want to have your newly inserted key returned by sqlserver...
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: Deleting Master database
not through sqlserver itself.
stop sqlserver service .
delete the mdf/ldf file
now someone is in deep sh..
Restore ?
follow the rebuildmaster procedure (see bol or ms-website)
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,976 through 6,990 (of 7,502 total)