Programming SQL

Theoretical question about index fragmentation in filegroup partitions
Hello, Question: Why does index fragmentation for one nonclustered table index vary so much by filegroup partition? Background: We have several very large tables. One of those tables, "SalesEntry," has a partitioned index. Each index partition is in a separate filegroup, and each filegroup is on a separate h... 22 Feb 2010 19:50

Theoretical question about index fragmentation in filegroup partitions
Hello, Question: Why does index fragmentation for one nonclustered table index vary so much by filegroup partition? Background: We have several very large tables. One of those tables, "SalesEntry," has a partitioned index. Each index partition is in a separate filegroup, and each filegroup is on a separate h... 23 Feb 2010 15:53

Read Uncommitted Data
I am trying to figure out how locking works and need some help in understanding the concept. For instance, there is a delete statement in a transaction that has not yet been committed. I would like to read this data before it is committed. How do I go about reading this data. I've tried reading this using NoLock bu... 22 Feb 2010 17:35

Why did TRAN COMMIT?
I have a stored procedure with several TSQL statements inside a transaction as follows: BEGIN TRAN T1; ....4 TSQL commands (inserts, etc.) IF @ProgramID = 4 BEGIN DECLARE @Notes nvarchar(100) DECLARE @OrigDate date SET @Notes = N'Check writing for check number ' + (SELECT CAST(CheckNumber As var... 22 Feb 2010 15:19

output to html
Hello Folks, Just looking for an "easy" to take the outputs of a sql server to HTML. TIA, ... 22 Feb 2010 18:43

First n records of x groups
Imagine a table containing car models characteristics. I want to select the first n records for each car brand. Can somebody help me? Thanks. Luciano ... 20 Feb 2010 15:47

marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 36832
Contato: marvendas(a)gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ ... 19 Feb 2010 23:19

syntax error (at stored proc)?
Hi, I am not sure what is the issue. I got following error. "Incorrect syntax near '@Param'." Bottom is the stored procedure. --------------------------------------------------------- CREATE PROC [dbo].[spCreateUser] @Param nvarchar(50) AS BEGIN CREATE USER @Param FOR LOGIN @Param END --------------... 19 Feb 2010 21:07

using backslash ( \ ) inside Parameter
Hi I am trying to use backslash as a part of a parameter at stored procedure. And I am getting syntax error. For instance, to execute like this.. EXEC spSetupPermissions CORP\ABC, Sale with parameter I have set up like this.. CREATE PROC [dbo].[spSetupPermissions] @USERNAME varchar(50), ... 19 Feb 2010 22:13

Automating a Cluster Group Failover
Is anyone aware of a utility or a script that is available that would allow an automated failover of a SQL Server Virtual Cluster Resource Group to another node in the cluster? Would like to call it out remotely via a scheduler process or SQL Agent.. thanks ... 19 Feb 2010 07:39