• Need help setting Transaction Log properties in SQL Server 2000

    I'd like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been...

    KansasCoder40 pointsBadges:
  • SQL Server 2005 database mirroring over a VPN router

    Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Case sensitive variables in SQL Server 2008

    Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...

    ITKE346,035 pointsBadges:
  • Storing a file in a database versus the file system?

    Performance-wise is there a big difference between storing a file in a database (e.g., mssql) versus the system? It sees to me that outside of application portability I would want to store my files as varbinaries in SQL Server?

    ITKE346,035 pointsBadges:
  • Import CSV file to SQL Server 2012

    I'm looking to import roughly 10,000 rows (this is from a CVS file) into an existing SQL Server 2012 table. I only have 1 column to import but there's another table in my column titled "TypeID". For this column, I need to set a static value like this: 99E05902-1F68-4B1A-BC66-A143BFF19E37INSERT INTO...

    ITKE346,035 pointsBadges:
  • SQL Query

    Employee: EmpID Name Company MGR_ID Date_of_Joining 1 Bhaskar A3 3 1-Jan-13 2 Ujin A1 3 1-Jan-13 3 Rex A6 NULL 1-Jan-13 Model: ID Model_Name Company Model_Type Harddisk OS RAM 1 750 Dell PC 600 GB WIN 7 4 GB 2 650 HP LAPTOP 400 GB WIN 7 6 GB 3 350 DELL LAPTOP 300 GB WIN 7 4 GB System: ASSET_ID...

    InformaticanSQL10 pointsBadges:
  • Use SQL INSERT to Create Directories with FileTable

    This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server. Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?

    ITKE346,035 pointsBadges:
  • Full text indexing in SQL Server Express

    Now, I've recently installed SQL Server 2012 Express Advanced Services, which is supposed to have Full-text indexing. I've already confirmed that it's running in SQL but when I try to create a full-text catalog, for some reason it fails. I continue to get this message: "Full-text is not supported...

    ITKE346,035 pointsBadges:
  • SQL Server 2012 Question: How to find last executed queries by database?

    Is there a way to find the last executed queries for a specific database in SQL Server 2012? I am able to find them using SSMS, but I don’t want to use SQL Profiler if I don’t have too. This is the query I’ve used to get the complete list of last executed queries. SELECT...

    ITKE346,035 pointsBadges:
  • Error message when restoring a SQL Server 2000 backup to 2012

    While I was restoring a backup from SQL Server 2000 to SQL Server 2012. This is the error I'm receiving currently:Msg 3169, Level 16, State 1, Server FF101, Line 1 The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running...

    ITKE346,035 pointsBadges:
  • SQL Server 2008: INSERT statement

    One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

    ITKE346,035 pointsBadges:
  • Can you create an Active Directory users group in SQL Server 2008?

    I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...

    Chris Leonard4,300 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Notification change in SQL Server 2008

    Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).Another service queries the databases for changes and uses the new data for processing.I used a configurable timer that...

    ITKE346,035 pointsBadges:
  • Altering a column in SQL Server 2000 (Not Null)

    I have a table in SQL Server 2000 that has several null-able integer columns. These are not working for me so I'm trying to update all nulls to 0 and then set the columns as "NOT NULL" (But the data must be preserved). Is there a specific SQL Syntax that could set the columns this way?

    ITKE346,035 pointsBadges:
  • Removing duplicate rows in SQL Server?

    I’m working with a large table (450,000+ rows). Many of the rows contain duplicate data and I’d like to be able to pull the dupes out. What is the best way to do this knowing that the rows are not fully duplicates due to the RowID identity field.MyTable ----------- RowID int not null...

    ITKE346,035 pointsBadges:
  • What is the most efficient way to implement pagination in SQL Server 2008?

    I am trying to find the most efficient way to implement paging within SQL Server 2008, using ASP.NET MVC and LINQ. Should I use LINQ's Skip() and Take()or implement my own pagination with a SQL query?

    Chris Leonard4,300 pointsBadges:
  • Color is different in SQL Server 2012 ReportViewer

    A friend of mine recently installed SQL Server 2012 with Reporting Services. When he actually selects a report, the filter/input bar (which is connected to the report) has a blueish look. But, when he's using the ReportViewer server control version, he gets the old beige look (as in previous...

    ITKE346,035 pointsBadges:
  • Looking to create and populate a numbers table in SQL Server 2005

    Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate

    ITKE346,035 pointsBadges:
  • How to split a string in SQL Server 2005?

    While in SQL Server 2005, how do I split a string so I can access item x? Let’s say I have a string “Peyton Manning”. Is there a way to split the string by adding a space and accessing the item at index 1 so that it reads "Peyton"?

    ITKE346,035 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