Forum Replies Created
Viewing 15 posts - 6,781 through 6,795 (of 7,499 total)
-
RE: Where clause on vertical Name/Value pair tables
How about :
SELECT A1.ProductID
FROM tblProductAttributeValues A1
inner join tblProductAttributeValues A2
on A1.ProductID = A2.ProductID
and A2.Active = 1
AND A2.AttributeID = 15
AND A2.AttributeValue =1
inner join tblProductAttributeValues A3
on A1.ProductID = A2.ProductID
and A3.Active...
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 2K to SQL 7.0
No, but you can use dts to export/import the data.
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: Switching recovery models
Basicaly simple recovery works like this :
Your log is still in use for data-transaction-integrity. Once data gets committed, the space used in the log for that transaction is marked for...
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: Index Page VS Data Page
Check
- Table and Index Architecture in BOL
- http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp
- http://www.sqlservercentral.com/columnists/sjones/sqlserver2000indexing.asp
- http://www.sqlservercentral.com/columnists/dharris/indexesanoverviewandmaintenanceforperformance.asp
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: Switching recovery models
To perform PIT(point in time)-recovery we perform log-backups before every other type of backup.
If you are not interested in PIT-recovery, you can fall back to other ways :
- make frequent full...
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: Excel/SQL Server - Limit Access To Authorised Data?
You could start with a simple view test.
Start sql Query analyser and build a query the has all the security-features in it wich you desire.
E.g.
Create Myview
as
Select mycol1 from sales...
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: Hide SQL server instance(s)
Hi Brian,
You'll off course have to select the server-instance which you want to alter the tcpip properties.
I have a server with 3 virtual instances and all 3 are listed in...
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: Excel/SQL Server - Limit Access To Authorised Data?
If you can build the query/procedure which contains the mechanism to determine "their clients" only, you can implement that.
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: Hide SQL server instance(s)
Maybe this is what you are looking for :
SQL Server Network utilities (Server-box)
TCPIP-properties
Hide server
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: Index Creation....
That is what it is supposed to do. !!
clusterd as discribed in BOL :
CLUSTERED
Creates an object where the physical order of rows is the same as the indexed order...
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: seperate out timestamp?
it can take a while, but you'll get used to 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
-
RE: seperate out timestamp?
In sqlserver there is no such thing as date or time, you only have datetime and smalldatetime which is date with time.
If you 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: how to IF NULL then value = 0
UPDATE [pitable].[dbo].[allpi]
SET val32= isnull(
(SELECT *
FROM OPENQUERY(pcnh, 'SELECT value as vh3 FROM picomp WHERE time = date(''*'') AND tag = ''HQ0MP001MX''
')),0)
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 restrict SELECT permission for sysadmin users... SQL server 2000
Indeed, it is like a fence. It prevents most from coming in, but soner or later, someone will jump over it.
Keep your DRP in mind when you choose a datasecurity...
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 restrict SELECT permission for sysadmin users... SQL server 2000
in addition to the other replies.
You can also try to disencourage native db-access by using your own naming-conventions.
I have one db that has tables named A0001,.. with columns C0001,...
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,781 through 6,795 (of 7,499 total)