Forum Replies Created
Viewing 15 posts - 38,656 through 38,670 (of 39,466 total)
-
RE: Run away Memory
Perf does this automatically. In profiler, there is a data column for starttime.
Steve Jones
-
RE: Storing and Retrieving Binary Data in SQL Server
This is an old example and article from Les and I'm not sure he will update this. I'll build an example soon and post it.
Steve Jones
-
RE: Version Control - Dealing with Code
Thanks for the feedback and I may update the article with some of these items (or write a more detailed one).
You are correct in your assumptions. I manually order the...
-
RE: Adding Global variable to import
If this is SQL 2000, you can use the Dynamic Properties task to change the data pump.
Steve Jones
-
RE: DTS Error
This error looks like you do not have change rights to the file. Ave you checked that?
There might be a 255 char limit.
Steve Jones
-
RE: select from a table
Follow Pau;s advice. This is not possible directly except with dynamic sql.
Steve Jones
-
RE: SQL Server Administration
Also the information_schema.xx views are SQL standards. There are:
tables
columns
etc. check master/views for the list.
Steve Jones
-
RE: Just got SQL Error 823...
PLs do. This is one reason I avoid Temp tables if possible. There are more bugs associated with temp tables.
Steve Jones
-
RE: Run away Memory
You will have to use the timestamps to correlate them. You are trying to match an event in Profiler with the worsening or changing performance in Performance Monitor.
Steve Jones
-
RE: solaris client and Sql Server 7.0
I'll look. I know there is an ODBC for Unix. There's also a project at GNU to translate the TDS (SQL protocol) for Unix.
Should have some info tomorrow.
Steve Jones
-
RE: Problem with hung up Maintenance job
I hate to say it, but you probablty need a reboot. Disable the job and then check the logs. We'll keep thinking.
Steve Jones
Viewing 15 posts - 38,656 through 38,670 (of 39,466 total)