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

    ITKE351,905 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

    ITKE351,905 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"?

    ITKE351,905 pointsBadges:
  • Changing/disabling foreign key constraints in SQL?

    Is it possible to enable and disable foreign key constraints in SQL Server? I’d prefer to avoid using 'drop and re-'create' to manage the constraints.

    ITKE351,905 pointsBadges:
  • How can we add a column (with a default value) to a table in SQL Server 2005?

    Our business is using an older version of SQL Server (2005 in fact) and all we're trying to do is add a column, with a default value, to an existing table. Can someone point us in the right direction?

    ITKE351,905 pointsBadges:
  • 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...

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

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

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

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

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

    ITKE351,905 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)?

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

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

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

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

    ITKE351,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!

    ITKE351,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?

    ITKE351,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...

    ITKE351,905 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