|
|
| |
History
|2003|2002|
Two FAQ questions were added:
How do I get the date the object was created?
How do I run SQL script located on the disk file, using Transact-SQL?
MSSQLCity.Com contains:
60 articles
122 FAQ questions
27 scripts
197 tips
4 test exams (on 75, 70, 10 and 10 questions)
New Tips topic with 12 tips was added:
Stored Procedures Optimization Tips
MSSQLCity.Com contains:
60 articles
120 FAQ questions
27 scripts
197 tips
4 test exams (on 75, 70, 10 and 10 questions)
Four FAQ questions were added:
How do I add 'n' working days to the given date and get the result date?
How do I get working days between two dates?
How do I return the first day of the month for the given date?
How do I return the last day of the month for the given date?
MSSQLCity.Com contains:
60 articles
120 FAQ questions
27 scripts
185 tips
4 test exams (on 75, 70, 10 and 10 questions)
New Tips topic with 12 tips was added:
Backup/Restore Optimization Tips
MSSQLCity.Com contains:
60 articles
116 FAQ questions
27 scripts
185 tips
4 test exams (on 75, 70, 10 and 10 questions)
Three FAQ questions were added:
How do I go about using/changing my settings to use the SANs protocol?
How do I report information about current users and processes?
How do I report information about the active locks?
MSSQLCity.Com contains:
60 articles
116 FAQ questions
27 scripts
173 tips
4 test exams (on 75, 70, 10 and 10 questions)
One T-SQL script was added.
One SQL Server 6.5 script was added.
MSSQLCity.Com contains:
60 articles
113 FAQ questions
27 scripts
173 tips
4 test exams (on 75, 70, 10 and 10 questions)
This article was added:
How to troubleshoot backup/restore problems
MSSQLCity.Com contains:
60 articles
113 FAQ questions
25 scripts
173 tips
4 test exams (on 75, 70, 10 and 10 questions)
Three FAQ questions were added:
Can I work with registry from within T-SQL?
How can I create extended stored procedures?
How do I move tables from one filegroup to another?
MSSQLCity.Com contains:
59 articles
113 FAQ questions
25 scripts
173 tips
4 test exams (on 75, 70, 10 and 10 questions)
New Tips topic with 14 tips was added:
DTS Optimization Tips
MSSQLCity.Com contains:
59 articles
110 FAQ questions
25 scripts
173 tips
4 test exams (on 75, 70, 10 and 10 questions)
Three FAQ questions were added:
I can run DTS package myself, but cannot schedule it.
I get the full-text search timeout error. How can I fix this?
Why DTS Import Wizard fails when importing table with a timestamp column?
MSSQLCity.Com contains:
59 articles
110 FAQ questions
25 scripts
159 tips
4 test exams (on 75, 70, 10 and 10 questions)
This article was added:
How to troubleshoot DTS problems
MSSQLCity.Com contains:
59 articles
107 FAQ questions
25 scripts
159 tips
4 test exams (on 75, 70, 10 and 10 questions)
New demo exam with ten questions was added:
MS SQL Server 2000 Administration
MSSQLCity.Com contains:
58 articles
107 FAQ questions
25 scripts
159 tips
4 test exams (on 75, 70, 10 and 10 questions)
New Tips topic with 20 tips was added:
Replication Optimization Tips
MSSQLCity.Com contains:
58 articles
107 FAQ questions
25 scripts
159 tips
3 test exams (on 75, 70 and 10 questions)
Two FAQ questions were added:
Can you give me the links to upgrade from SQL 7.0 to SQL 2000?
Should I apply the SQL service packs in order or can I just apply the latest one?
MSSQLCity.Com contains:
58 articles
107 FAQ questions
25 scripts
139 tips
3 test exams (on 75, 70 and 10 questions)
This article was added:
How to troubleshoot replication problems
MSSQLCity.Com contains:
58 articles
105 FAQ questions
25 scripts
139 tips
3 test exams (on 75, 70 and 10 questions)
Three FAQ questions were added:
How can I rebuild the SQL Server repository?
I am a dbowner. Can I restrict access to my database for the 'sa'?
Where can I find the list of bugs fixed by SQL 2000 service packs?
MSSQLCity.Com contains:
57 articles
105 FAQ questions
25 scripts
139 tips
3 test exams (on 75, 70 and 10 questions)
New Tips topic with 14 tips was added:
Full-Text Search Optimization Tips
MSSQLCity.Com contains:
57 articles
102 FAQ questions
25 scripts
139 tips
3 test exams (on 75, 70 and 10 questions)
Four FAQ questions were added:
What are good SQL Server web resources?
Where can I download free case tools?
Where can I download SQL Server 2000 Books Online?
Where can I see the price-list for SQL Server?
MSSQLCity.Com contains:
57 articles
102 FAQ questions
25 scripts
125 tips
3 test exams (on 75, 70 and 10 questions)
This article was added:
How to troubleshoot full-text search problems
Two Miscellaneous optimization tips were added.
MSSQLCity.Com contains:
57 articles
98 FAQ questions
25 scripts
125 tips
3 test exams (on 75, 70 and 10 questions)
Two FAQ questions were added:
How can I send a message to user from the SQL Server?
How do I run a T-SQL script through SQL-DMO?
MSSQLCity.Com contains:
56 articles
98 FAQ questions
25 scripts
123 tips
3 test exams (on 75, 70 and 10 questions)
New demo exam with ten questions was added:
MS SQL Server 2000 Development
MSSQLCity.Com contains:
56 articles
96 FAQ questions
25 scripts
123 tips
3 test exams (on 75, 70 and 10 questions)
This article was added:
Setup full-text search: step by step guide
MSSQLCity.Com contains:
56 articles
96 FAQ questions
25 scripts
123 tips
2 test exams (one contains 75 questions, another contains 70 questions)
Two FAQ questions were added:
How can I get the column's description from my stored procedure?
I got an error that RPC is not enabled. How can I enable RPC?
MSSQLCity.Com contains:
55 articles
96 FAQ questions
25 scripts
123 tips
2 test exams (one contains 75 questions, another contains 70 questions)
Two T-SQL optimization tips were added.
MSSQLCity.Com contains:
55 articles
94 FAQ questions
25 scripts
123 tips
2 test exams (one contains 75 questions, another contains 70 questions)
Two FAQ questions were added:
How can I fix lost users after attaching database with sp_attach_db?
How to troubleshoot SQL Server installation problems?
One T-SQL script was added.
MSSQLCity.Com contains:
55 articles
94 FAQ questions
25 scripts
121 tips
2 test exams (one contains 75 questions, another contains 70 questions)
Four SQL Server 6.5 optimization tips were added.
Three questions were added in MS SQL Server 7.0 Administration questions pool.
MSSQLCity.Com contains:
55 articles
92 FAQ questions
24 scripts
121 tips
2 test exams (one contains 75 questions, another contains 70 questions)
Four FAQ questions were added:
Can I use the SQL Server 7.0 tools to connect to SQL Server 2000?
How can I check from the SQL Server whether the file exists or not?
How can I decrypt a SQL Server stored procedure?
How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?
MSSQLCity.Com contains:
55 articles
92 FAQ questions
24 scripts
117 tips
2 test exams (one contains 72 questions, another contains 70 questions)
Two FAQ questions were added:
How can I add SQL Server licenses?
How is SQL Server licensed?
Two Operation System optimization tips were added.
Three questions were added in MS SQL Server 7.0 Development questions pool.
MSSQLCity.Com contains:
55 articles
88 FAQ questions
24 scripts
117 tips
2 test exams (one contains 72 questions, another contains 70 questions)
One T-SQL script was added.
One SQL Server 6.5 script was added.
Two questions were added in MS SQL Server 7.0 Administration questions pool.
MSSQLCity.Com contains:
55 articles
86 FAQ questions
24 scripts
115 tips
2 test exams (one contains 72 questions, another contains 67 questions)
This article was added:
Using SQL Server Cursors
New Tips topic with 9 tips was added:
Cursor Optimization Tips
MSSQLCity.Com contains:
55 articles
86 FAQ questions
22 scripts
115 tips
2 test exams (one contains 70 questions, another contains 67 questions)
This article was updated:
Date and Time User-Defined Functions
Four FAQ questions were added:
Where can I find MSSQL test exams?
What is the current service pack for SQL Server 7.0?
What is the current service pack for SQL Server 2000?
Where can I find the list of bugs fixed by SQL 7.0 service packs?
Two questions were added in MS SQL Server 7.0 Development questions pool.
MSSQLCity.Com contains:
54 articles
86 FAQ questions
22 scripts
106 tips
2 test exams (one contains 70 questions, another contains 67 questions)
Four SQL Server 2000 optimization tips were added.
Three questions were added in MS SQL Server 7.0 Administration questions pool.
MSSQLCity.Com contains:
54 articles
82 FAQ questions
22 scripts
106 tips
2 test exams (one contains 70 questions, another contains 65 questions)
Two FAQ questions were added:
Some of my text/image values were not replicated. What is the problem?
Where does snapshot replication store replicated data?
Two questions were added in MS SQL Server 7.0 Administration questions pool.
Two questions were added in MS SQL Server 7.0 Development questions pool.
MSSQLCity.Com contains:
54 articles
82 FAQ questions
22 scripts
102 tips
2 test exams (one contains 67 questions, another contains 65 questions)
Three FAQ questions were added:
Can I backup a database to a network device?
How do I restore the master database?
We have no any backup, can we restore deleted data?
One T-SQL script was added.
One SQL Server 6.5 script was added.
MSSQLCity.Com contains:
54 articles
80 FAQ questions
22 scripts
102 tips
2 test exams (one contains 65 questions, another contains 63 questions)
Two SQL Server 2000 optimization tips were added.
Five questions were added in MS SQL Server 7.0 Administration questions pool.
Three questions were added in MS SQL Server 7.0 Development questions pool.
MSSQLCity.Com contains:
54 articles
77 FAQ questions
20 scripts
102 tips
2 test exams (one contains 65 questions, another contains 63 questions)
This article was updated:
SQL Server 7.0: Some useful trace flags
Two FAQ questions were added:
How can I compare the data in two tables with identical structure?
How can I compare two databases?
New Tips topic with 8 tips was added:
SQL Server 2000
MSSQLCity.Com contains:
54 articles
77 FAQ questions
20 scripts
100 tips
2 test exams (one contains 60 questions, another contains 60 questions)
| April 1, 2002 - the site birthday. |
MSSQLCity.Com contains:
54 articles
75 FAQ questions
20 scripts
92 tips
2 test exams (one contains 60 questions, another contains 60 questions)
|2003|2002|
|
|
|