??Z?k ??????ra? ???s???
Wed, 18 Mar 2009 22:42:56 -0700
...
|
??Z?k ??????ra? ???s???
Wed, 18 Mar 2009 22:42:55 -0700
...
|
SQL Server Management Studio Server List
Tue, 17 Mar 2009 15:58:27 -0700
In SQL Server 2005 Management Studio, the Connect to Server dialog has
a combobox for "Server name" that remembers any servers I have ever
connected to.
Some of those servers no longer exist. Is there a way to remove
entries? ...
|
SSMS 2008 Super Buggy
Tue, 17 Mar 2009 14:48:09 -0700
We updated some servers from 05 to 08.
We soon found out you couldn't do queries in 05 to an 08 server.
So the DBAs installed SSMS on their xpp sp2 boxes. Only SSMS not the
database.
Well if you try to edit a proc you get nothing but error squiggleys.
The sprocs complile but all the invalid error messages a ...
|
statistics for performance
Mon, 16 Mar 2009 14:34:26 -0700 (PDT)
I have a request to run Statistics on a DB/Schema.
This will improve response time and query performance for a clients
data.
I have never done this. New to SQL Server.
Can some please provide me some ideas what needs to be done. Also,
how does the statistics improve performance?
Thanks ...
|
Management Studio 2005 fails to start - How to fix?
Mon, 16 Mar 2009 13:28:29 -0700
Hi
When I start SQL Management Studio 2005 SP3 the following message comes up.
Could not load file or assembly 'EnvDTE, Version=8.0.0.0, Culture=neutral,
PublicKey Token=b03f..." or a one of its dependencies. The system cannot
find the file specified.
What's my next step?
Thank you
Greg
...
|
Moving SQL Server Tools Installation to a New Drive
Wed, 11 Mar 2009 09:35:01 -0700
A client installed SQL Server 2005 on his C drive. Unfortunately, the drive
has run out of space, primarily due to Windows and SQL Server.
I've already moved the tempdb and production databases to a new drive.
To move the tools, is it a matter of Add/Remove Programs to uninstall them
and then reinstallin ...
|
|
|
ANN: SQL Image Viewer 2.2.0.110 released
Wed, 11 Mar 2009 11:06:44 +0800
We've recently released SQL Image Viewer 2.2.0.110, a tool for retrieving,
viewing, transforming and exporting images stored in your SQL Server
databases. Supported image formats are bmp, gif, jpg, png, psd and tiff.
In addition, SQL Image Viewer can identify binary data in the following
formats: pdf, mp3, ...
|
Include Execution time of queries in SQL 2005 Maintenance Plan
Tue, 10 Mar 2009 14:21:02 -0700
We have a maintenance plan on SQL Server 2005 that we would like to show the
execution time of each query in the log file like it was setup in SQL Server
2000. Is there a way to do this in SQL Server 2005 and thinking in advanced
in SQL Server 2008 as well? Current we are running SQL Server 2005 SP2.
Tha ...
|
Problem profiling SQL 2000 server from 2008 profiler
Tue, 10 Mar 2009 05:03:01 -0700
I am trying to run the Tuning profile in SQL Server Profiler 2008 against an
SQL Server 2000 database, but I get the following error message when I try to
start the trace:
---------------------------
SQL Server Profiler
---------------------------
Failed to start a trace.
[Microsoft][SQL Server Native Cli ...
|
