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

    ITKE346,285 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!

    ITKE346,285 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?

    ITKE346,285 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...

    ITKE346,285 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...

    ITKE346,285 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?

    ITKE346,285 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...

    ITKE346,285 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.

    ITKE346,285 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.

    ITKE346,285 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...

    ITKE346,285 pointsBadges:
  • SQL Server 2012 Express has slowed down dramatically

    I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...

    ITKE346,285 pointsBadges:
  • Having problems with remote access: SQL Server 2008 R2

    I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...

    ITKE346,285 pointsBadges:
  • Using NOLOCK in SQL Statement (SQL Server 2008)

    This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...

    ITKE346,285 pointsBadges:
  • Auto-trimming issue in SQL Server 2008

    I have a weird problem. Why in the the following SQL query does print 'equal' when run against SQL Server 2008. The database compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal'And this returns 0: select (LEN(' '))I think its auto trimming in space. Anyone know if...

    ITKE346,285 pointsBadges:
  • Receiving error message connecting to SQL Server 2008 R2

    I'm trying to connect to SQL Server 2008 R2 using Windows authentication. However, I can't because I keep getting this error:Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]Now, I can log in...

    ITKE346,285 pointsBadges:
  • Is it possible to use ASCMD in SQL Server 2012?

    While using SQL Server 2008 R2, I was able to execute ASCMD SSAS queries. We recently upgraded to SSAS 2012 servers and I hope to reinstall all my maintenance scripts. I can't find any ASCMD tools in SQL Server 2012, nor any documents on the internet. When I try to execute a query I get the...

    ITKE346,285 pointsBadges:
  • Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE346,285 pointsBadges:
  • SQL Server 2012 CONCAT producing strange characters.

    Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...

    ITKE346,285 pointsBadges:
  • Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE346,285 pointsBadges:
  • Remote Call issues in SQL Server 2008 R2

    I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...

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