Questions & Answers

  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE829,010 pointsBadges:
  • Cleaning MySQL InnodB storage engine

    I have a friend who needs to clean his MySQL InnoDB storage engine because it's still storing data from deleted tables. Is it possible to do that? Does he have to create a new database every single time? Thank you.

    ITKE829,010 pointsBadges:
  • How to export / import MySQL databases

    For my job, I have to make sure to backup all of our MySQL databases (there's over 100). For this, can I export all of them at the same time, followed by importing them into the server? Is that possible?

    ITKE829,010 pointsBadges:
  • Is a MySQL primary key indexed automatically?

    Hello experts, Would anyone know if a primary key is automatically indexed in MySQL? Do I actually have to create the index? Also - would this be possible in InnoDB too? Thanks!

    ITKE829,010 pointsBadges:
  • MySQL database export using Command Prompt

    I have a pretty large MySQL database and I need to export it ASAP. Can I use the Command Prompt to do this? Or is there another way?

    ITKE829,010 pointsBadges:
  • What data type should I use for storing currency values in MySQL?

    I'm using MySQL and I'm wondering what's the best data type if I want to store currency values in it. Is there a certain command?

    ITKE829,010 pointsBadges:
  • See indexes on MySQL database

    Specifically for MySQL, can I see if my database has any indexes? If not the database, can I see on a particular table? Appreciate the help.

    ITKE829,010 pointsBadges:
  • Select all MySQL columns except for one

    Is there a statement in MySQL that would select all of my columns (except for one specific column) in a table? Please note that there's roughly 50 columns in total. Thanks for the help!

    ITKE829,010 pointsBadges:
  • Trace MySQL queries on Linux server

    I'm using my Linux server and I was hoping there's a way to trace all of my live MySQL queries. Is that possible? I have a listener set up already (if that helps).

    ITKE829,010 pointsBadges:
  • Show last MySQL queries on servers

    How can I show the last queries executed on all of my servers in MySQL? Is there a specific query to do this?

    ITKE829,010 pointsBadges:
  • Should I switch over to SAP BI?

    I am working as a Lead QA Analyst (Manual Testing). I don't have a programming knowledge. Now I want to switch over to SAP BI not in testing. So before that I want to know if I can do SAP BI. Still is it having scope? I asked my friends but still I didn't get proper answers. So I'm eagerly waiting...

    Harumraj5 pointsBadges:
  • Incremental backup

    Can I perform incremental backup without having initial full backup?

    srithea360 pointsBadges:
  • How to script entire SQL Server database

    Does anyone know if there's a possible way to get a script of an entire SQL Server database? I'm taking about columns, tables, stored procedures, etc. Thank you.

    ITKE829,010 pointsBadges:
  • Store IP address in SQL Server

    Is there a specific datatype I should use for storing my IP address in SQL Server? Furthermore, when I select the datatype, will it be easy to filter my IP address?

    ITKE829,010 pointsBadges:
  • SQL Server 2008: Maximum number of characters for NVARCHAR

    In SQL Server 2008, I just declared one of my columns as type NVARCHAR (Max). What would be the maximum number of characters for the NVARCHAR? Thanks!

    ITKE829,010 pointsBadges:
  • Storing passwords in SQL Server database

    What's the best way to store my passwords in a SQL Server database (it's actually for 2008 and 2012)? For the past few years, I've been using a .NET encryption library, followed by storing them in the database. Should I continue with this method or figure something else out?

    ITKE829,010 pointsBadges:
  • Delta or incremental backup in AS/400

    How can I do a delta or incremental backup in AS/400?

    Babs312290 pointsBadges:
  • Find SQL Server 2008 port

    Over the past few months, I've been running SQL Server 2008 on my machine. My default port is 1433 but it's currently not listening at this port. I still can't find it - I tried SSMS and registry but nothing is working. What can I do?

    ITKE829,010 pointsBadges:
  • Find current SQL Server database transaction level

    How can I find the current SQL Server database's transaction level? Thank you very much

    ITKE829,010 pointsBadges:
  • NAND memory flash has to be reprogrammed in Avaya 9611-g

    This happens in those kind of phones, Avaya 9611-g and 9608-g 9621-g. Do you know why the NAND memory flash after be reprogrammed, if you try make phone call, it's impossible when you have two phones that were reprogrammed even with new flash.

    rolandolopez5 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