Search results for query: *

Back again, I'm trying to write this View and it continues to fail. I honestly don't know what is going wrong. As I mentioned earlier. I'm having to create the View in one db and then query the data to another db. The tables in both db's are different. I'm just trying to get to the second db to...

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.

Greetings, I'm pretty slow at SQL for as long as I've been associated with SQL Server. But non the less... I have a query that runs correctly until I attempt to add a group by. I know it must be something not too difficult, but, I'm at a loss. select [Entry No_], [Sale No_], [Posting Date]...

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...