Viewing 15 posts - 1,096 through 1,110 (of 3,543 total)
Ninja's_RGR'us (4/25/2011)[hrAnd yes you should be insulted :hehe: :-D.
Bummer. Now I'll have to go and sit on the naughty chair :blush:
April 25, 2011 at 5:59 am
GilaMonster (4/22/2011)
With no IT experience, it's not likely you'll be able to land a DBA job. Developer, maybe.
Wow Gail! Not sure whether, as a developer, I should feel insulted by...
April 25, 2011 at 5:41 am
Grant Fritchey (4/25/2011)
... I usually bump mine up to 35 or so on OLTP systems.
Is that a general rule of thumb?
Are there any consequences to that setting?
April 25, 2011 at 5:30 am
Nice riposte Jeff 🙂
I consider myself remonstrated :crying:
My only dabble with SDF was on a scanner with an older version of CE to SQL2K via Web Service. I believe the...
April 25, 2011 at 1:07 am
SQLkiwi (4/24/2011)
toddasd (4/21/2011)
I didn't know INSERT could have a TOP clause.
It's a good thing to know, because SET ROWCOUNT will not work with INSERT, DELETE, or UPDATE in the next...
April 24, 2011 at 6:42 am
Jeff Moden (4/23/2011)
Pardon my ignorance. What's an "SDF"?
Crikey Jeff, I'm agog with amazement :hehe:
You being a SQL god an 'all 🙂
I guess DBA's don't venture out of the sandbox...
April 24, 2011 at 6:37 am
Syed Jahanzaib Bin hassan (4/24/2011)
Did you read this statement in the end of my post
Yes but why did you post code to generate data when the poster already had data...
April 24, 2011 at 6:29 am
This is also posted at http://www.sqlservercentral.com/Forums/Topic1094538-391-1.aspx
April 24, 2011 at 2:44 am
At a guess, something like this
WITH cte ([ServerName],[Database Name],[Month],[DB-Size])
AS (
SELECT [ServerName],[Database Name],DATEDIFF(month,GETDATE(),[Execution date]) AS [Month],[DB-Size]
FROM
WHERE [Execution date] >= DATEADD(month,DATEDIFF(month,0,GETDATE())-12,0)
AND [Execution date] < DATEADD(month,DATEDIFF(month,0,GETDATE()),1)
AND...
April 24, 2011 at 1:54 am
scott.gach-667672 (2/2/2009)
Is there any way to break out of the loop if one of the scripts fails?
Add -b parameter, check ERRORLEVEL and use GOTO after each file is processed may...
April 22, 2011 at 6:17 am
Not sure if this would be faster, depends on a lot of factors ie indexes, volume and other types or data not specified
SELECTt.[type],
sp1,
cl1 AS [pr],
da,
d.m,
m.cu,...
April 21, 2011 at 8:43 am
SELECT a.COL1,a.Col2,a.Col3,a.Col4
FROM (
SELECT a.COL1,a.Col2,a.Col3,a.Col4
FROM #TABLE1 a
EXCEPT
SELECT b.COL1,b.Col2,b.Col3,b.Col4
FROM #TABLE2 b
) a
UNION ALL
SELECT b.COL1,b.Col2,b.Col3,b.Col4
FROM (
SELECT b.COL1,b.Col2,b.Col3,b.Col4
FROM #TABLE2 b
EXCEPT
SELECT a.COL1,a.Col2,a.Col3,a.Col4
FROM #TABLE1...
April 21, 2011 at 8:06 am
What are you trying to change it to?
If you are trying to change sqlzealot-81 to sqlzealot than you cannot as sqlzealot already exists as a username(nickname). The system was changed...
April 21, 2011 at 6:30 am
Have you tried?
If so post DML and error plus DDL and test data
April 21, 2011 at 5:06 am
In a delete trigger you have a 'deleted' table containing the rows to be/have been deleted so you can use this to update ie
UPDATE c
SET c.IsEnabled=0
FROM dbo.COUNTRY c...
April 21, 2011 at 4:12 am
Viewing 15 posts - 1,096 through 1,110 (of 3,543 total)