Question : I have written code in Visual Studio.NET and used data from SQL Server 2008. After debugging, it says: […]
Tag: sql-server-2008
Task scheduler for SQL Server Express
Question : I have an ASP.NET MVC app which works with database under SQL Server 2008 R2 Express edition. There […]
Auto Update Statistics in SQL Server 2008R2: Why do some statistics remain stale despite a large number of row inserts?
Question : During investigation of a slow query it appeared that the execution plan was exceptionally suboptimal (A nested loop […]
Data sharing between client and server two ways
Question : One of my Silverlight applications is running. This Application is using one central database (SQL Server 2008) and […]
Sql server 2008 filestream maximum number of rows
Question : We are using filestreams in Microsoft SQL Server 2008 (SP2) – 10.0.4000.0 (X64) and Windows server 2008 to […]
Log Sequence Numbers in Full BackUp and Log Backup
Question : My full back-up starts daily at 02:00 AM. It takes about 3 hours. I also take T-Log back-ups […]
Easily show rows that are different between two tables or queries
Question : Imagine you have two different tables/queries that are supposed to have/return identical data. You want to verify this. […]
Adding Data to Multiple Tables Using Single Query [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Detecting SQL Server Utilization with a query
Question : My current project will send queries to an sql server constantly and It may use 100% of the […]
How to convert rows into columns in sql server using pivot or with out pivot
Question : How to convert rows into columns in sql server? This is my query output: I need like.. ServiceName […]