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

    ITKE54,905 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!

    ITKE54,905 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?

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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?

    ITKE54,905 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...

    ITKE54,905 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.

    ITKE54,905 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.

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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...

    ITKE54,905 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)...

    ITKE54,905 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?

    ITKE54,905 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...

    ITKE54,905 pointsBadges:
  • Controlling VPN access

    Here's my scenario. I fall under guidelines of HIPAA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...

    Gforsythe75 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