Q by EVX
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me.
This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in an[......]
Q by SQL Server Ask the Experts
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up[......]
Q by SQL Server Ask the Experts
I just installed SQL Server 2005 Developer Edition and I can’t find the user interface. I’m looking for the place I’d type queries as I did in SQL Server 2000 Enterprise Manager. Where can I find the UI?
Re by Mrdenny
That would be the SQL Server Management Studio. St[......]
Q by SQL Server Ask the Experts
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?
Re by Mrdenny
In SQL Server 2000 you should be using the INFORMATION_SCHEMA views. In SQL Server 2005 and up you should refer to the system views. [......]
Q by daveSTC
Is there a SQLServer equivalent to being able to retrieve internal application specific metadata that to the users/roles v.s. object privs (select, insert, update, delete, execute, etc.) ? In oracle it’s achieved by forming SQL selecting data from the appropriate "dba_" [......]
Q by SQL Server Ask the Experts
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Re by Mrdenny
No, the table will be locked while the index creation command is running.
Original Address: http://itknowledgee[......]
Q by Mnman66
I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!
Re by Mrdenny
The migration tool an[......]
Q by HL
please tell me which one performs better view or temp table ?
Re by Mrdenny
That will depend on what you are doing. Temp tables and vies are totally different from each other. Typcially views are not stored on disk, and the data have to be queried from the disk. Temp tables take the data th[......]
Q by FrankKulash
In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there’s a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITIO[......]
Q by Tian8168
Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,
Re by Mrdenny
Under the server, open security, then logins. I[......]
.NET WYSIWYG HTML Editor (100% FREE)
1Tree
Access Password Recovery (100% FREE)
Advanced Date Time Calculator
Auto Mail Sender
Date Time Counter
Duplicate File Finder Mini (100% FREE)
Easy Work Time Calculator
Email Checker Basic (100% FREE) Email Checker Pro
File & Folder Lister (100% FREE)
Free Online Color Converter (100% FREE)
KeyMusic (100% FREE)
Online PHP Syntax Checker (100% FREE)
PC WorkBreak (100% FREE)
Process Guard for Developer (100% FREE)
tail for Windows (100% Free)
VB 6 Pure Code Lines Calculator (100% FREE)
Windows Explorer Tracker (100% FREE)
PC Freeware Recommended