Viewing 15 posts - 1,501 through 1,515 (of 3,221 total)
From:
http://technet.microsoft.com/en-us/magazine/2007.02.sqlqa.aspx
Database Mirroring
Q I am using database mirroring and want to enable the READ_COMMITTED_SNAPSHOT database option. When I try to enable it after the mirroring has been set up, I...
January 25, 2011 at 5:00 pm
chris.s.powell (1/25/2011)
select [FileSizeMB] = convert(numeric(10,2)
, round(a.size/128.,2))
,...
January 25, 2011 at 4:48 pm
1. Your abstract does not identify to whom this is of the most interest.
How about including: As a DBA responsible for multiple servers ......
2.
This session will walk...
January 24, 2011 at 10:57 am
On the db side, we want to move to SQL Server so that we can transfer/load/integrate the data from our warehouse vendor into more meaningful, relevant data that we use...
January 24, 2011 at 10:00 am
With your data as given:
CREATE TABLE #Table1(empid INT, name VARCHAR(20), Date DATETIME)
INSERT INTO #Table1
SELECT 1,'name1','12/01/2011 8:00:00 am' UNION ALL
SELECT 1,'name1','12/01/2011 4:00:00 pm' UNION ALL
SELECT 1,'name1','12/02/2011 8:00:00 pm'...
January 23, 2011 at 3:23 pm
Here is a tool writen by Jeff Moden and posted to SSC. It might be just what you need.
CREATE FUNCTION [dbo].[DelimitedSplit8K_old]
/***************************************************************************************************
Purpose:
Split a given string at a given...
January 23, 2011 at 10:40 am
Knowing that you stated you could not change the table(s), but in this examle I did, adding an Identity field (Row) to keep from going nuts when reviewing the results....
January 23, 2011 at 9:52 am
Suggest you start reading with this site
http://technet.microsoft.com/en-us/library/ms345368(SQL.90).aspx
January 22, 2011 at 11:14 am
Look at this product by REDGATE SOFTWARE
January 22, 2011 at 7:27 am
Will this example assist you?
CREATE TABLE [dbo].[TranTest](
[Col1] [int] NOT NULL,
[Col2] [int] NULL,
CONSTRAINT [PK_TranTest] PRIMARY KEY CLUSTERED
(
[Col1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...
January 22, 2011 at 7:01 am
Perhaps this example might help you undestand what Gsquared and Gilamonster have stated.
--This is your inner SP
CREATE PROCEDURE Tran_02
@Error INT OUTPUT
AS
DECLARE @E INT
...
January 21, 2011 at 2:11 pm
LutzM (1/21/2011)
GilaMonster (1/21/2011)
...Yes, and I got a second meeting invite for Monday afternoon. Accepted that cause I just don't feel like fighting any more.
Unfortunately, a term like "mañana" seems not...
January 21, 2011 at 8:08 am
Since you did not supply the table structure or data, I made up my table and populated it with my data:
CREATE TABLE #T(Sales MONEY,DayofSale DATE)
INSERT INTO #T(Sales,DayofSale)
SELECT 100.10,'01-02-2009' UNION ALL
SELECT...
January 20, 2011 at 8:53 pm
Luke L (1/20/2011)
Grant Fritchey (1/20/2011)
Steve Jones - SSC Editor (1/20/2011)
January 20, 2011 at 2:05 pm
Ninja's_RGR'us (1/20/2011)
The only question here is how much is the license...
January 20, 2011 at 11:56 am
Viewing 15 posts - 1,501 through 1,515 (of 3,221 total)