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

    ITKE436,035 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.

    ITKE436,035 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?

    ITKE436,035 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?

    ITKE436,035 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...

    ITKE436,035 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!

    ITKE436,035 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.

    ITKE436,035 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...

    ITKE436,035 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.

    ITKE436,035 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:
  • SQL Server 2008: Counts within a date range

    I need to be able to count an id and the ids duplicates when the createdate is >= 3 months or 90 days (whatever is easier) for the ids createdate. I'm using temp tables and any help would be appreciated as I'm farily new to SQL id CreateDate Counts_id 1 01/01/2015 2 1 04/01/2015 2 2 01/01/2015 1...

    jrming015 pointsBadges:
  • Hanging session in SQL Server

    A session is in KILL/ROLLBACK state for some time. I do not want the database to become inconsistent and would like some help on the steps on how to solve this. kill 85 with statusonly; SPID 85: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0...

    Mia123455 pointsBadges:
  • Recover records on SQL Server 2008 table

    In my remote SQL Server 2008 table, I accidentally deleted over a million records. Now, the server won't let me back in and access to the backup files on the server side. How can I get some of these records back?

    ITKE436,035 pointsBadges:
  • Copy SQL stored procedure from local to live database

    Hello, I want to copy multiple procedures from a local database to a live database?

    vikasbhatt25 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 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.

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

Following