• Creating instance for SQL Server 2008 installation

    I've recently installed Visual Studio 2012 Professional and SQL Server 2008 SP1. My next move was to install SQL Management Studio x64 and I did get the option to set the instance name. I had several options including:Instance Feature Shared features 1. Management Tools-Basic 2. SQL Client...

    ITKE344,900 pointsBadges:
  • Uninstalling SQL Server 2008 R2 manually

    When I'm using my Windows 7 Ultimate x64, I honestly can't do anything with the existing instance of my SQL Server 2008 R2. I made the mistake of uninstalling some requirements related to SQL Server before running the main uninstaller.It seems like the uninstaller is doing its job (it's saying all...

    ITKE344,900 pointsBadges:
  • What is the fastest way to find a string in SQL Server 2012 R2?

    I’m using MS SQL Server 2008 R2 to develop a large table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title column: varchar, char, text, whatever. Column Title contains random text strings like "abcdefg", "q", "mybigfatgreektitle" with maximum of 255 chars. I need to...

    ITKE344,900 pointsBadges:
  • 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!

    ITKE344,900 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE344,900 pointsBadges:
  • Who is using a database in SQL Server 2008?

    I’ve never seen this problem before. I went to change the name of a database in SQL Server 2008, but got hit with an error message saying that the db has to be exclusively locked to do this. So obviously someone else is using the database, but I don’t know who. We have a rather large...

    ITKE344,900 pointsBadges:
  • Exporting SQL Server 2005 database to SQL Server 2008

    This is more a basic question but is it possible to import (or migrate) SQL Server 2005 databases to SQL Server 2008? Or can I have 2005 and 2008 running on the same machine (without any complications)?

    ITKE344,900 pointsBadges:
  • Row-level security in SQL Server 2012

    I've noticed something different about the row-level security in SQL Server 2012. In earlier versions, the only was views. Now in 2012, they announced something like this:Row Level Security in Tabular ModelsCan someone explain to me what this is?

    ITKE344,900 pointsBadges:
  • How to transfer SSIS Tasks from 2008 R2 to 2012

    I am about to switch from SQL Server 2008 P2 to SQl Server 2012. I use a number of custom SSIS Tasks on 2008 R2 and I’d like to know if it’s possible to transfer them to 2012; and of course if it is possible, how to do it. I tried just opening my DTSX packages in Visual Studio 2010 but they...

    ITKE344,900 pointsBadges:
  • Checking the existence of a user in SQL Server

    I'm looking to drop a user in a SQL Server script but the only problem is I need to test for the actual existence or I'll start to get script errors. Can someone tell me what his the corollary for checking for a user?

    ITKE344,900 pointsBadges:
  • Pagination via Entity Framework and SQL Server 2012

    I’d like to use Entity Framework 5 to change pages using Take + Skip. I’ve heard that SQL Server 2012 provides a better way for paging using FETCH and OFFSET which could have a big impact on performance. Does Entity Framework 5 support this? Will the LINQ queries be translated into the new 2012...

    ITKE344,900 pointsBadges:
  • Does SQL Server Data Tools work with SQL Server 2008 (SSIS)?

    I'm trying to figure out if I can use SQL Server Data Tools (that comes with SQL Server 2012) to create SSIS packages for SQL Server 2008. Basically, I just want to use SSDT to create / maintain SSIS on both 2008/2012. Thanks!

    ITKE344,900 pointsBadges:
  • Backup error message in SQL Server 2012

    I'm using SQL Server 2012 and in my database, I have filestream enabled. But when I try to backup it and restore it on another SQL Server 2012 (on another machine), I keep getting this message:No backupset selected to be restored.What's this mean? Is the filestream causing the issue?

    ITKE344,900 pointsBadges:
  • In place upgrade from SQL 2008 R2 DEV to SQL 2012 SQL

    I have been working with SQL Server for many iterations and from the old days I remember the mantra “Do NOT do an in-place upgrade.” I'm about to upgrade from 2008 R2 DEV and TEST systems to SQL Server 2012 using the same hardware. I want to do it this way so that I don’t have to reconfigure...

    ITKE344,900 pointsBadges:
  • Did the Database Designer change for Visual Studio 2012?

    I've recently installed Visual Studio and SQL Server 2012 onto my machine. I've noticed the Database Designer isn't as 'friendly' as the old version. Here are some of the changes I've noticed:It creates .SQL scripts instead of automatically saving my changes.I have to update different things in...

    ITKE344,900 pointsBadges:
  • What comes first? Visual Studio 2012 or SQL Server Management Studio 2012?

    I am preparing a fresh install of SQL Server 2012 onto a Windows 7 x64 development VM. I plan to coordinate this with Visual Studio 2012. Does the install sequence matter? Which of the two should I install first to cut down on issues?

    ITKE344,900 pointsBadges:
  • Receiving error message when restoring database backup

    I keep getting this error in SQL Server 2012 when I'm trying to restore a backup made with a previous version (SQL Server 2008). The newest files are restoring fine but here's the error I'm receiving for other files:System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM...

    ITKE344,900 pointsBadges:
  • Creating a SQL script for determining if a sequence exists

    I'm looking to create a SQL script to see if a sequence exists in my SQL Server 2012 database. I understand the concept of stored procedures but not with sequence.

    ITKE344,900 pointsBadges:
  • Should I use SQL Server 2008 R2 or Postgre 9?

    I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.

    ITKE344,900 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE344,900 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