|
|
|
Reindex doesn't work
Thu, 30 Jul 2009 04:15:01 -0700
I have a table with a single index. (Unique on primary key, clustered)
Each morning the index needs to be rebuilt for some reason. In my program
which accesses the table, response time is about 15 seconds. After I rebuild
the index, it becomes < 2 seconds.
I created a maintenance plan to reindex. It is:
...
|
Tool for migrating from one db schema to another?
Mon, 27 Jul 2009 10:27:01 -0700
I am migrating from one SQL-based help desk system to a competing one. I have
a few hundred tickets to migrate to the new system. What is the proper tool
for migrating data in this case, where the databases are different? For
example, I want to be able to tell the tool that TicketID in tblTickets in
SourceDB ...
|
ANN: SQL Scripter 3.0 released
Sat, 25 Jul 2009 06:23:01 -0700
SQL Scripter is an easy to use data export, import, scripting and reporting
utility for Microsoft SQL Server (MSSQL).
- Generate T-SQL Data Scripts (Insert, Update, Delete)
- Quick Scripter (Script all table in a single step)
- Save and re-use templates
- Command line support
- Export Data to Text/CSV file
...
|
ERD/Diagrammer tool for SQL Server
Thu, 16 Jul 2009 17:35:28 -0700 (PDT)
Hello,
I am looking for a tool that builds ERDs and Database diagrams and
from these generate the database scripts to create the schema. This is
the main thing I am looking for; building the database, generating
create script from the diagram.
1. Does Microsoft have such a tool?
2. Does VisioStudio allow one ...
|
active trace running on sql server
Wed, 15 Jul 2009 16:50:01 -0700
Hi,
I just found out from performance dashboard that there is an active trace
running. I have no idea when it is started. Is there a way to stop the trace?
Is the tracing part of the server background process that starts
automatically when you start the server?
Traces Report
© 2006-2007 Microsoft Corpora ...
|
Management studio with "evaluation period has expired"
Mon, 13 Jul 2009 07:17:02 -0700
Hi
at a few months ago we made a Small business install and a few days ago we
start getting a message from management studio evaluation "period has expired"
that aplications into the server are working well.. and we made a sp1
install and correction into reg like this kb article
http://support.microsoft.co ...
|
seksi djevojka
Fri, 10 Jul 2009 17:55:48 -0700
...
|
|
|
seksi djevojka
Fri, 10 Jul 2009 17:55:47 -0700
...
|
performance dashboard
Thu, 9 Jul 2009 10:43:01 -0700
I have it installed. How do I collect data and look at the report?
Thanks.
Pingx ...
|
ANN: SQL Image Viewer 2.3.0.119 released
Tue, 7 Jul 2009 10:35:32 +0800
SQL Image Viewer helps you retrieve, view, convert and export images and
binary data stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and
various ODBC-supported databases (e.g. DB2 and PostgreSQL).
It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF,
and recognises the following ...
|
|
|