Viewing 15 posts - 1,096 through 1,110 (of 3,544 total)
Oh! And BTW I have seen some DBAs I would not like as my last line of defence :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
April 25, 2011 at 6:03 am
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:
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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?
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 24, 2011 at 6:29 am
This is also posted at http://www.sqlservercentral.com/Forums/Topic1094538-391-1.aspx
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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,...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 21, 2011 at 6:30 am
Have you tried?
If so post DML and error plus DDL and test data
Far away is close at hand in the images of elsewhere.
Anon.
April 21, 2011 at 5:06 am
Viewing 15 posts - 1,096 through 1,110 (of 3,544 total)