Viewing 15 posts - 376 through 390 (of 607 total)
GilaMonster (6/12/2013)
Sean Pearce (6/12/2013)
1. Create new filegroup.
2. Create new file on new filegroup. Set this to your required size.
3. Rebuild all indexes with the new filegroup...
June 12, 2013 at 3:15 pm
You are welcome.
You can also use ISNULL instead of creating a new condition.
DECLARE @T TABLE
(StartDate DATETIME,
EndDate DATETIME,
Comments VARCHAR(255));
INSERT INTO @T VALUES ('2013-01-01 01:00', '2013-01-01 04:00', 'Not needed');
INSERT INTO @T VALUES...
June 12, 2013 at 8:26 am
$w@t (6/12/2013)
can anyone explain me what is happening here?????
OPENROWSET (Transact-SQL)
Includes all connection information that is required to access remote data from an OLE DB data source. This method is an...
June 12, 2013 at 4:51 am
GilaMonster (6/12/2013)
SQL Show (6/12/2013)
Gail,Will You advice any workaround to reclaim space?
Patience. 🙂
Why are you shrinking anyway? Has the database been permanently reduced in size? Will the space you're trying to...
June 12, 2013 at 4:43 am
DECLARE @T TABLE
(StartDate DATETIME,
EndDate DATETIME,
Comments VARCHAR(255));
INSERT INTO @T VALUES ('2013-01-01 08:00', '2013-01-01 16:00', 'Overlapping Both Ends');
INSERT INTO @T VALUES ('2013-01-01 08:00', '2013-01-01 12:00', 'Overlapping Front');
INSERT INTO @T VALUES ('2013-01-01 13:00',...
June 12, 2013 at 3:45 am
mrbonk (6/11/2013)
Is that enough info?
No. We need the actual execution plans and DDL for your tables and indexes.
June 12, 2013 at 3:22 am
wolfkillj (6/10/2013)
I would consider adding a line of code that writes those values to a log table so I could view their values later.
SELECT
recipients,
copy_recipients,
blind_copy_recipients,
send_request_date,
sent_date,
sent_status
FROM
msdb..sysmail_allitems
June 11, 2013 at 7:29 am
DBA_007 (6/10/2013)
since sqlserver is the only one running in the machine why do we need to set Max memory settingas it can allocate memory dynamically when ever required
since sqlserver is...
June 11, 2013 at 7:25 am
ben.brugman (6/10/2013)
If everything seems to be going well, you have obviously overlooked something.
For me it's not obvious what I am overlooking, hence the question.
Don't mistake the cheeky signature line as...
June 11, 2013 at 7:17 am
ben.brugman (6/10/2013)
The output from a stored procedure is often a resultset which is or is similar to a table.
Output from a stored procedure MIGHT be a resultset. What do you...
June 11, 2013 at 7:14 am
Insert your data into a staging table then check for duplicates there:
SELECT KeyColumn
FROM StagingTable
GROUP BY KeyColumn
HAVING COUNT(*) > 1;
June 11, 2013 at 6:48 am
Dird (6/7/2013)
To fix this you need to declare a decimal type (if in a procedure) or convert to float or decimal:
select 1/cast(2 as float);select convert(decimal(8,2), (1))/5;
A simple decimal point will...
June 11, 2013 at 6:33 am
This behavior is due to data type precedence.
The following query might help you understand better:
-- This fails
SELECT 1
UNION
SELECT 'One'
-- This works
SELECT '1'
UNION
SELECT 'One'
June 11, 2013 at 5:28 am
One thing that stands out is the number of Key Lookups in each plan. Viewing the actual plans would be useful though.
June 11, 2013 at 3:19 am
sachin6139 (6/4/2013)
June 11, 2013 at 2:50 am
Viewing 15 posts - 376 through 390 (of 607 total)