Forum Replies Created
Viewing 15 posts - 6,976 through 6,990 (of 7,498 total)
-
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
-
RE: Linked Server to DB2 using IBMs OLEDB Provider (IBMDADB2)
is this db2 on os390 or AS400 or UDB on win/unix/..
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: Corrupted DB Help Needed
you've already been advised to use sp_attach_db ... (see bol)
Then perform the checkdb
Any backup-files ??? (full / diff / log)
All ddl scripted nicely ?
Review you backup-schema !
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
oh please stay with CODD' s rules !
http://www.sqlservercentral.com/columnists/fkalis/coddsrules.asp
Basics of any RDBMS :
- know your relationships.
- use meaningless keys. It makes schema-knowlage mandatory ! and will avoid symantic errors !
-...
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: recopile after schema changes
the rough way :
- Select 'exec sp_refreshview @viewname = ''' + u.name + '.'+ o.name + ''' ' + char(13) + ' go '
from sysobjects o
inner join sysusers u...
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,498 total)