SQL Server Tag Directory

Featured SQL Server Questions

  • It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • Comparing results of two MDX query using c#

    Hi, I have to run two MDX query source and target query. And compare the results and show the difference alone. I'm writing the script using C#. Here is the sample code which I'm using I'm able to retreive the cellset but not sure about compare. int col_dim_count_source; int row_dim_count_source;...

    arunpradeepa5 pointsBadges:
  • Best value for fillfactor in SQL?

    What is best value for fillfactor in SQL?

    mukeshkumar1210 pointsBadges:
  • How to find a word starting with (‘a’,’b’,’c’,’d’,’e’ or ‘f’) and end with ‘z’ from table.

    How to find a word starting with ('a','b','c','d','e' or 'f') and end with 'z' from table.

    mukeshkumar1210 pointsBadges:
  • SOP for cleaning Server rooms

    Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces - cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require...

    Sinead5 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • connect sql server with tcp/ip how can i do?

    connect sql server with tcp/ip how can i do?

    DangerM5 pointsBadges:
  • Scheduling join queries in AS/400

    I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?

    ITKE342,795 pointsBadges:
  • Help joining data into table 1 from table 2 SQL

    I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.

    JustAnotherITguy60 pointsBadges:
  • How to check Max Worker Threads in SQL Server 2005

    We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

    BrentSheets6,925 pointsBadges:
  • Merging the MDF and NDF files of SQL Server databases

    How can i merge the MDF and NDF files of SQL Server databases?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cannot find server name

    I’ve just started learning ASP.net and I installed Visual Studio 2010 and Microsoft SQL Server 2008. When I connected SQL server management studio to the server message box and tried to enter a server name, the connection failed. How can I find the name of the server? Is there something else I...

    ITKE342,795 pointsBadges:
  • Using JOIN in SQL Server 2012

    I’m trying to create a list of all our employees by last name with their dependents by first name, and birth dates. My output columns are emp_last_name from the employee table and dep_name and dep_date_of_birth. Here is what I’ve specifically been tasked with doing: Use alias table names. Name...

    ITKE342,795 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • Is their a RDBMS for the Macintosh Operating System

    Is their a RDBMS for the Macintosh Operating System. I am looking for something similar to Microsoft SQL Server for Mac. Ideally something that would interface with Microsoft Office for Mac.

    BarryCC5 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 pointsBadges:
  • Joining unmatched tables with duplicates

    Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get the...

    jruth1325 pointsBadges:
  • How to make fast indexing and flat text search in SQL database

    Our objective is to achieving good speed with Full-Text Search on an MS-SQL/2008, using Sphinx DB Indexing and text search engine. Our challenge: can we reach speeds better than 3 sec/per simple term search on a DB containing about 2GB of data / 200+ tables with complex permission system...

    Eid24305 pointsBadges:
  • Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server

    Hello, I am getting the below error on customer production error, Query timeout expired - State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC's record sets. if I try to run that queries on SSMS directly I am not getting that error. How...

    Narasimhulu10 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 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