Search results for query: *

...data to another db. The tables in both db's are different. I'm just trying to get to the second db to return a result. CREATE VIEW dbo.vInstrumentBalanceDue AS SELECT * FROM LRM_Instrument_Tracking.'any_table_name' go SELECT Balance, No. FROM dbo.LARS-Prod$.lease WHERE Balance <> 0

Thanks, Appreciate the information guys.

Greetings, I'm trying to write a view that resides in one db1."table" (that doesn't contain the same table as db2) and selects from db2.Lease table. Both db's are in the same SQL Server. I thought I read somewhere that a view you are executing (selecting) from an application had to have reside...

Thanks for the feedback. You're correct about the not agregating (Is that a word?)the columns which are in the Select into the Where clause.

...[Posting Date] from "LARS-403-Test$Timber Ticket Ledger Entry" where [Posting Date] between '2006-02-02' and '2006-12-02' order by [Sale No_] /*group by [Posting Date]*/ Entry No_ Sale No_ Posting Date --------- --------- ----------------------- 263015 SS500056...

Hello Everyone, I have a developer who (really not me) has filled a log to 75GB and I'm trying to truncate the log and reduce the log file size. 1. Checkpointed the database 2. Backed up the DB 3. Performed a dbcc shrinkfile ('LARS_TEST_40003_Log', truncateonly) 4. Used DBAtrisan to check the...

I'm using DBArtisan's DataUpload wizard and I have moved the dumps from the other machine to the new SQL Server's local machine . The reason I had to move the dumps (memory key migration, the new "sneaker net") is that a non-sa/dba web designer kept moving everything around before I arrived in...

Approx. 7 years ago when I was a full-time, large systems dba, dbid's had to match or the system catalogs wouldn't link the db to the system's objects and nothing would recover (this was Sybase: MS SQL Servers source code). If this isn't the case, then how does the SQL Server function currently?

I'm migrating 4 db's off the machine from Hell (development server thrust into production) onto a permanent production sql server on another file server. The current db dbids are in the left column and the new db's dbids to migrate to are in the right column: Asset 7 7 GFPB 10 6...

Thanks to everyone for your help....

Hey Everyone, I have an application that I need to install and it hangs at 91% on C:\WINDOWS\Fonts\Tahoma.ttl (I would assume the other Tahoma Bold as well if it gets to it). I was told by the Software manufactuer\distributer to either: 1) Rename them or 2)Delete them. I'm sys admin and I'm...

Thank you for the referal Edimator. Craig Webber

I need some help designing database tables. I have years of DBA/SA experience, but have tried to stay away from coding, Well life has caught up with me: I have to create a Cell Phone Billing database and have the following general logical design for five tables: BillingCharges (PlanType is a...

Thanks to everyone for your responces...

Thanks for your time gradley, it's there. Craig

Sorry, I went Tools > Data Transformation Services > and right-clicking doesn't respond with anything. All I get is Import or Export Data...

I'm sure this obvious but, I'm looking around trying to find info on DTS Designer. Where is it? I can't find any info on how to get it or install it.

I'd love to use it or DBArtisan 8.0, but I can't get to the machine on the Domain. I can access it locally, but I can't perform any network(ing) connectivity to migrate objects (dbs).

If nothing else, SELECT * is selecting all the data from all of your rows. That is 70,000 rows x 28 columns = 1.96 million / 4 minutes (240 seconds) = 8,16666...7 rows per second. It also depends on your system and if it is dedicated to the SQL Server or sharing resources.

I have a problem with migration. Due to issues too complicated (insane) to discuss, the problem is I have to migrate from a first development SQL server (poorly configured by a Web developer) that was turned into a production server. I had to build a new production SQL server on a new file...