Browse by Tags
All Tags »
SQL Server (RSS)
Just find few useful tips/tool when I try to compare the schema and content of two SQL databases: DBComparer (free) Find out DB lock: select distinct object_name(a.rsc_objid), a.req_spid, b.loginame from master.dbo.syslockinfo a (nolock) join master.dbo.sysprocesses
Read More...
With the principle of least privilege of application / database account, web app normally uses a DB account with limited permission to specific database objects in Connection String. Manually typing of "GRANT EXECUTE ON <Object> to <User>"
Read More...
I am trying to perform a database attach upgrade to SharePoint Foundation 2010. At this point I am trying to attach the content database to a Web application by using Windows Powershell: Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer
Read More...
When trying to install SQL Server 2008 Service Pack 1 to a SQL Server 2008 instance that is running on a virtual machine, the installer will start: But then after about 20 seconds I receive the following error message: TITLE: SQL Server Setup failure.
Read More...
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000...
This site is a resource for asp.net web programming. It has examples by Peter Kellner of techniques for high performance programming
Apart from the capacity planner tool for System Center and SharePoint Server, I was looking for a tool which can help me to estimate the capacity of SQL Server. I found an article on Microsoft.com for SQL Server 2000 sizing but unfortunately the links
Read More...
I am moving a SQL Server database from one drive to another by detaching and then reattaching. I detached the database, moved the mdf and ldf files, and then went to attach it and was presented with this dialog: TITLE: Microsoft SQL Server Management
Read More...
When trying to do a full text search with SQL Server 2008 I received this error: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start
Read More...
I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio: Saving changes is not permitted. The changes you have made require the following tables to be dropped
Read More...
I am creating a standard sign up form with one of the fields being a country drop down. So I created my Country database table and then needed to fill it with information. I found the ISO list of countries here , but then the issue was how to get that
Read More...
osql.exe is a great application for running sql scripts in a batch. I use a batch file to execute multiple sql scripts that I use to rebuild my current application database from scratch. When developing a brand new application, deploying a
Read More...
There are so many different ways to work with data that it can make your head spin. Regardless of the technology, one thing I always try to do when working with databases is minimize the number of calls that are made. I use ORM frameworks
Read More...
In SQL Server you can specify a column as an Identity column (ColumnName int IDENTITY(1,1) NOT NULL) to have SQL Server automatically set the value of this column upon insert by incrementing a seed value. This works great but I have run into situations
Read More...
One of the projects my company is currently working on has a requirement to be able to store timesheet data in a more flexible manner. The existing Access forms application is being converted to Silverlight 3 and has a fairly rigid (albeit standard)
Read More...
If you are looking to follow this series, be sure to subscribe to my RSS feed at http://feeds.jasongaylord.com/JasonNGaylord or my Twitter account at http://twitter.com/jgaylord . This series can be followed by using the Hot Links tag. Series Post #12
Read More...