• Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE380,130 pointsBadges:
  • SQL Server 2012 query errors

    In SQL Server 2012, I'm running several queries but not all of them are working. The first one goes through but not the second. Also, when I try to run it without the WHERE clause, everything fails. The queries are below. Thank you. create table #temp (id int primary key) create table #temp2 (id...

    ITKE380,130 pointsBadges:
  • SQL Server: Document databases

    Over the course of the past month, my department has noticed that several of our clients are not documenting their SQL Server databases and that's making us worried. First off, should we be worried? If so, then what should we do? Thanks!

    ITKE380,130 pointsBadges:
  • SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE380,130 pointsBadges:
  • SQL Server: Insert number of rows into a table

    I have a SQL Server database where I currently upload files into a staging table. On the table, I have 2 JOINs that corrects foreign keys. That's followed by putting these rows into one final table. Right now, there's roughly over 3 billion rows of data. Now here's my question: What's the best (or...

    ITKE380,130 pointsBadges:
  • Restore SQL Server .BAK file and shrink log size at the same time

    I currently have a .BAK file that was sent to us by one of our clients and this was because of an issue the file is having. Our backup is 25 GB and the database is roughly the same size but it actually needs 100 GB to be restored. We think that the database has a 75 GB transaction log size. Can we...

    ITKE380,130 pointsBadges:
  • We have a virtual environment build up recently and we have started facing IO issues and disk perf. issue

    Virtual servers build recently have 4 cores and 16 GB memory on them need to know what is the best baseline for SQL servers as we have started facing IO issues and disk performance issues. Min CPU requirement Min Memory requirement Disk provisioning  - what is recommended thick or thin

    SQLDBA215 pointsBadges:
  • Is cloud just a hype and still not ready to replace on-premise Windows Application and SQL Database Small Server?

    Is Cloud just an 'EARLY BIRD' Hype where Cloud and Internet 4G Technology still not ready to replace "On-premise Windows Application and SQL Database Small Server" in terms of Network Bandwidth Speed and Infrastructure Cost - just to fund IT Giant's R&D and Cloud Marketing activities - when...

    VijithaIvor10 pointsBadges:
  • SQL Server 2008: Write SELECT query to CSV file

    For SQL Server 2008, I'm writing a SELECT query results to a CSV file. Can I do this using T-SQL? And I don't have access to SSIS too (I know you can do it there). Someone told me to use BCP utility - would that work? Thank you in advance.

    ITKE380,130 pointsBadges:
  • How to fix a SQL Server database that’s stuck in a restoring state

    Our department currently has a SharePoint server. But our network administrator mis-configured the backup tool (it was Symantec Backup Exec) and several of our SQL Server databases are stuck in restoring state. What should we do? Can we get these databases back?

    ITKE380,130 pointsBadges:
  • SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE380,130 pointsBadges:
  • Re-add user to SQL Express 2012 database

    About once every six months, I move our database (SQL Express 2012) from our development machine to our server. Usually, I use SSMS for backup and restore. But the apps on the target machine can't access the database until I get rid of the user they use and re-add it. Does anyone know if there's a...

    ITKE380,130 pointsBadges:
  • How to install SQL Server Management Studio locally on my desktop

    Does anyone know if I can install SQL Server Management Studio locally (meaning - on my desktop) so I could access my database on a SQL Server instance? I've seen the express version but I need something else.  Thanks!

    ITKE380,130 pointsBadges:
  • SQL Server 2012 – Profile stored procedures

    I'm currently using SQL Server 2012 and I'm trying to figure out if I can profile stored procedures. I need to capture each SQL Statement in my stored procedures (basically how long it takes to run). Thanks so much.

    ITKE380,130 pointsBadges:
  • Error message when restoring .BAK file on SQL Server

    I've been trying to restore a .BAK file on SQL Server for the past few days but I keep getting this error message: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot process this media family. I've tried several queries on 2008...

    ITKE380,130 pointsBadges:
  • SQL Server 2008: Assign Active Directory group security access

    On my domain, I need to have integrated security with my internal app. I've tried several times but it's never really worked out for me. Can I assign an Exchange / Active Directory group a role in SQL Server to have read/write access in specific tables? Just so everyone knows - this is for SQL...

    ITKE380,130 pointsBadges:
  • SQL Server: Get database name

    How do I get the database name and associated user mapped for all database in SQL Server?

    testsdf5 pointsBadges:
  • How to tell if my SQL Server database is still in use

    We have to get rid of a SQL Server instance (basically decommission it) but it still has several databases left on it. Is there a way to tell if these databases are still being used by our users? Thank you very much.

    ITKE380,130 pointsBadges:
  • Calculating moving average cost rate in SQL Server

    I am trying to calculate a moving average rate for stock valuation and profit margin calculation, we have following table: ProductID PurchaseQty PurchaseRate SaleQty SaleRate CostRate(Auto Calculate) ========================================================================= 1 4 500 0 0 500 =(2000/4)...

    mkfaiz5 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following