Viewing 15 posts - 61 through 75 (of 337 total)
Have you manually set the processor affinity or is it set to Automatic ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 10:00 pm
Do you require changes replicated between different subscribers ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 9:51 pm
It sounds that there are to many plans in your plan cache memory.10% of buffer pool memory from 4gb-64gb + 5%>64gb is allocated to plan cache.
Can you post the output...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 9:41 pm
In our SQL environment my observation always had been that TVP outperformed all the custom TSQL splitter functions and CLR methods.In some instances the TVP performance was on par with...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 8:58 pm
Also maybe this:
SELECT Datepart(yyyy, d.date) AS "Year",
Count(*) ...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 8:56 pm
Only scope of improvement I can see in the given state is to add an NC index on #OrderDetailsHistory for columns(TSID DESC,ActionCode,OrderID).
CREATE INDEX NCI_OrderDetailsHistory
ON #OrderDetailsHistory(TSID DESC,ActionCode,OrderID)
The APPLY clause...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2016 at 12:30 am
Yes I think you will have to run DBCC CHECKTABLE incase DBCC CHECKDB does not return any error.To run DBCC CHECKTABLE first identify all the possible tables that have LOB...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2016 at 11:34 pm
This ?
DECLARE @str VARCHAR(40)='ek/df/cv/'
DECLARE @strreverse VARCHAR(40)=Reverse(@str)
SELECT Substring(@strreverse, 1, Charindex('/', @strreverse) - 1)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 10, 2014 at 12:41 am
Is the column size for Clientname VARCHAR(64) enough ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 8, 2014 at 8:40 am
Out of curiosity wondering how does this perform ?
SELECT v.parcel,v.value
FROM @m M
JOIN @v-2 v
on v.Parcel = m.Parcel
group...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 6, 2014 at 12:24 am
Using SQL Server 2012 function in use
select * from
(
select
*,CUME_DIST () OVER (PARTITION BY marker ORDER BY val)-
RANK() OVER (PARTITION...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 4, 2014 at 10:40 am
One way would be to create a UDF to check the values and use that as constraint for the table.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 3, 2014 at 12:01 am
Make sure the Business Layer is ready.Never go for table design unless your business layer is not ready.That's my personal opinion.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 2, 2014 at 8:14 am
You will have to rollback the transaction in the CATCH block.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 2, 2014 at 8:06 am
My attempt at this one.
SELECT account,
checkindt,
CASE
WHEN...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
July 2, 2014 at 2:57 am
Viewing 15 posts - 61 through 75 (of 337 total)