Viewing 15 posts - 31 through 45 (of 116 total)
L' Eomot Inversé (6/8/2012)
440692 I am just a number (6/8/2012)
L' Eomot Inversé (6/7/2012)
... with which sensible people want as little to do as possible...
Why?
I only ask because I have just...
June 11, 2012 at 3:17 am
L' Eomot Inversé (6/7/2012)
... with which sensible people want as little to do as possible...
Why?
I only ask because I have just implemented database trigger where DDL events are recorded as...
June 8, 2012 at 1:21 am
I have always used a script template I found in another thread here
http://www.sqlservercentral.com/Forums/Topic437300-5-1.aspx
written by Jeff Moden
It is from 2007 and so may have been replaced with something even...
June 6, 2012 at 3:20 am
oops, I charged off in the wrong direction and was rightly brought back in line.
I have rewritten the the proc using a Tally Table
ALTER PROCEDURE [dbo].[GenerateSeries]
@int BIGINT = NULL
AS
BEGIN
;...
June 5, 2012 at 2:14 am
ALTER Procedure [dbo].[GenerateSeries]
@int int=NULL
AS
BEGIN
;WITH mycte AS
(
SELECT 1 id
, CASE
WHEN @int > 100 THEN 100
ELSE @int
END AS ToID
UNION ALL
SELECT
ID + 100
,(id + CASE...
June 4, 2012 at 5:20 am
Stewart,
looks good,I like the case statement on the join, if only I had thought of that ?
but adding in another year kinda throws the results out of squew
INSERT ProductSales
VALUES('Product...
May 24, 2012 at 3:53 am
I had hoped to be able to help, but I've run out of time.
I am happy to share with you what I have so far, in the hope that you...
May 24, 2012 at 2:03 am
Thank you great question.
Plus extra thanks to Hugo for the link
Hugo Kornelis (5/23/2012)
For a very complete discussion on this subject, read http://www.sommarskog.se/error_handling_2005.html.
May 23, 2012 at 4:05 am
Jo Pattyn (5/15/2012)
Have you checked for double-hop issues?
Thanks Jo
I will follow them up.
Ian
May 16, 2012 at 12:47 am
SQLDBA360 (5/15/2012)
May 15, 2012 at 9:25 am
sys.dm_exec_query_stats has a last_execution_time,
Does it help if you filter with that?
DECLARE @startfilter DATETIME
SET @startfilter = GETDATE() - 10
SELECT
DB_NAME(st.dbid) DBName
,OBJECT_SCHEMA_NAME(st.objectid,dbid) SchemaName
,OBJECT_NAME(st.objectid,dbid) StoredProcedure
,max(cp.usecounts) Execution_count
FROM sys.dm_exec_cached_plans cp
JOIN...
April 27, 2012 at 5:46 am
SQLDBA360 (4/25/2012)
Ian did you check the relationship between the 2x domains
The two domains are in the same forest.
The latest stand is, under a local system account we can log into...
April 25, 2012 at 8:04 am
Great question, thanks.
In the context of QotD, easy, but I reckon in a real life scenario it would take me a lot longer to find that answer.
April 20, 2012 at 1:19 am
440692 I am just a number (4/17/2012)
SQLDBA360 (4/17/2012)
One more silly question, hopefully my last, but the SQL Server Services are starting ok with the domain accounts?
Yes both servers start ...
April 17, 2012 at 4:22 am
SQLDBA360 (4/17/2012)
One more silly question, hopefully my last, but the SQL Server Services are starting ok with the domain accounts?
Yes both servers start OK with the domain accounts.
April 17, 2012 at 2:33 am
Viewing 15 posts - 31 through 45 (of 116 total)