SQL Server database programming

From multiple records in a table, for a datetime field I am trying to get the start/stop time for each range of times that doesn't have a gap of 15 minutes or more. Example Output desired from the example records below ...

I need recommendation on following tools for Performance Monitoring. These tools are from Idera. If you know any other competitior tool that perform better, please advice. SQL Diagnostic Manager SQL Defrag Manager -Nitin ...

Hi Everyone, I need help to reinitialize a subscriber subscription for merge replication. So far, B server has been take offline, a new B2 server was put in, and a DTS package moved all of the db in B to B2 . A has ...

Hello, I'm trying to work around the 4000 character limit w/ sp_executesql in SQL 2000 by breaking apart my query into two strings and passing them as parameters. To test this, I'm trying to make it work in a very ...

Hi Using SqlServer 2005. At a INSERT statement I want CustomId to increase with 1 depending on what the AppId are. CustomId must be unique per AppId. Any ideas on how to solve this? CREATE TABLE [Invoice] (     [Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL , ...

Hi, I have tables A, B and C that I've joined through a view called MYVIEW . In table B there is attribute B.orderby. It is not the primary key. When I "SELECT * FROM MYVIEW" I always want the results ordered by B.orderby. However, an ORDER BY in a CREATE VIEW is not allowed. ...