Forum Replies Created
Viewing 15 posts - 5,671 through 5,685 (of 14,953 total)
-
RE: replication urgent
lazy writer (12/14/2010)
HiI have created snapshot replication while creating this I have chosen options like generate snapshot immediately not on demand or schedule.
Here my doubt is for the snapshot...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: View is not ordered. Why?
Please keep in mind that the "fix" you used will only work if the database is set to Compatibility 80.
This means:
a) You won't be able to use the new 2005...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Server-side traces and reboots
Restarting the SQL service, whether from just restarting the service or from rebooting the server/VM, dumps all traces except the default trace (usually trace ID 1).
I'd take a look in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: loopin the XML Node,,,row by row process
For that, you'd use a cursor. But there's no reason to. You can use Output Into to insert all the rows at once, then get all the IDs...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Are the posted questions getting worse?
CirquedeSQLeil (12/14/2010)
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. 😀How about a horse stepping on an iMat?
...
iMat? You'll need DBCC...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: My SP runs lightning fast. Stick it in a report and it runs like a dog (a slow dog)
Any complex conditional formatting or nesting in the report?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Round to next 1000 or 100 without Ceiling function
Mark-101232 (12/14/2010)
Is the XQuery ceiling function allowed?WITH TESTDATA(Number) AS (SELECT 12307.96 UNION ALL
SELECT 2207.96
),
XMLData(data) AS (
SELECT Number AS "@Val"
FROM TESTDATA
FOR XML PATH('X'),ROOT('R'),TYPE
)
SELECT r.value('@Val','float') AS...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Round to next 1000 or 100 without Ceiling function
LutzM (12/14/2010)
Another option not using any of the ROUND/FLOOR/CEILING functions:PRINT (CAST(12307.96 AS INT)/1000 + 1)*1000Does it make sense to use it? I don't think so.
That won't "round" correctly if the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Create trace problem
Did you remember to turn the trace on? sp_trace_setstatus needs to be run to turn it on. Till you do that, it won't create any files.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: loopin the XML Node,,,row by row process
Use XQuery to shred the XML, and use an OUTPUT clause to get the IDs from the insert.
You'll start with this:
DECLARE @XML XML;SELECT @XML = '<Individual InternalID="154805" Action="Update">
<InsertUserID>ASDZXCCFG</InsertUserID>
<InsertDateTime>08-29-2008 17:13:57</InsertDateTime>
<UpdateUserID>SYSTEM_USER</UpdateUserID>
<UpdateDateTime>13-05-2010...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Are the posted questions getting worse?
Alvin Ramard (12/14/2010)
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. 😀How about a horse stepping on an iMat?
...
iMat? You'll need DBCC TimeWarp for...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Are the posted questions getting worse?
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. 😀How about a horse stepping on an iMat?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/14/2010)
GilaMonster (12/14/2010)
Thunderstorms here, but no snow storms. (I'd worry if there were)Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.
It almost...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Are the posted questions getting worse?
GilaMonster (12/14/2010)
Thunderstorms here, but no snow storms. (I'd worry if there were)Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.
It almost resulted in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
RE: Reuse of Identity column values
Caruncles (12/14/2010)
Yes, my first attempt was on a temp table of sequential numbers comparing to the live table.The only reason it matters is because I'm trying find out if...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 5,671 through 5,685 (of 14,953 total)