Viewing 15 posts - 47,536 through 47,550 (of 49,552 total)
SQL ORACLE (1/29/2008)
Could you open your master..sysdatabases, modify the column filename to the locations of your mdf and ldf files? Then, restart your services?
Modifying the system tables is not recommended...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 11:30 pm
Do you have any linked servers in use? Using CLR?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 11:28 pm
Please don't post the same question multiple times.
http://www.sqlservercentral.com/Forums/Topic449095-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 11:27 pm
If you check the parameters for bcp in books online, you'll note that it takes a single table. If you want to export multiple tables, run bcp multiple times.
Books Online
bcp...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 11:15 pm
fosco (1/29/2008)
would I have to restore all the previous log backup ( there are many of them and from what date).
Yes. You have to restore the log backups, in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 12:44 pm
Oh man! That's terrible news. I met him at Pass last year. Such a nice guy and so humble. Spoke about his work on management studio, and his plans for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 10:41 am
The transaction has to roll back. SQL Server guarantees that transactions are completed entirely, or not at all.
Even if you kill the SQL process and restart it, the rollback...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 10:32 am
Having is used to filter on aggregated values. For a simple filter on a column value, rather use where.
SELECT COUNT (*), State FROM T1 WHERE Sex = 'M' GROUP BY...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 10:29 am
Please don't post in all caps. It's the online equivalent of shouting.
Am I correct in saying you want to insert the resultset from a stored proc into a table? You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 6:43 am
Finally got round to trying on sql 2005. (SP 2 developer edition)
The LEN - index scan. Rated by the execution plan as 98% of the overall cost of the two...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 4:49 am
Could we see the entire connection string please?
Just before you do the pRs->Open, print the connections string to the debug (or similar) and post the result (remving the password...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 2:02 am
Can you post the connection string that you're using please?
Dunno about the login mde. Take a look at the properties of the server in enterprise manager and see what its...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 12:47 am
Your stored proc is written to take 3 parameters and you're passing it 4.
Create procedure dbo.IMPEXPFROMDB
@filepath varchar(255), --filepath
@direction varchar(5) , --direction(In/Out)
@tablename varchar(255) --Valid tablename/viewname
as
...
Exec IMPEXPFROMDB 'databaseTest' 'tableNameOne', 'OUT',...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 12:40 am
I prefer stored procs, from a point of code encapsulation. If the sql code is in the db, then I'm able to tune it if necessary. If the SQL statements...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2008 at 12:40 am
I think you'll get schema stability no matter what. The query has to ensure that the table isn't changing while the query's running.
Why's it necessary in your second process to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2008 at 1:39 pm
Viewing 15 posts - 47,536 through 47,550 (of 49,552 total)