Forum Replies Created
Viewing 15 posts - 7,726 through 7,740 (of 14,953 total)
-
RE: Is it possible to make a view on the registered servers?
My mistake. I was thinking of linked servers.
No, registered servers isn't something that's stored in the database. It's local application data.
You can export your registered server data into...
- 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: Alert for the SQL agents
You could set something up that will send an e-mail when the service stops. You'd have to write a program to send the alert, and then go to 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: Large Number of Tables (1,090,000)
At the very least, I would expect that to slow down metadata queries, which just about everything needs. Plus, you're going to have the execution plan cache absolutely jammed...
- 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: Is it possible to make a view on the registered servers?
Are you asking about creating a view to select from master.sys.servers?
- 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: REPLACE Multiple Spaces with One
TheSQLGuru (11/16/2009)
GSquared: did you try hard-coded space-strings instead of the pile of replicates? I would HOPE the optimizer would expand those on compile, but if it doesn't that...- 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: Surely It Should Just Work?
Steve Jones - Editor (11/17/2009)
GSquared (11/16/2009)
She has a Swiss Army knife, I have a locking-blade pocket knife.I think it's cool both you and your wife have knives 🙂
It's...
- 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 (11/16/2009)
Can Anybody help me explain group access and conn strings?No. I'm pretty sure only a limited subset of people can help with that.
- 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: REPLACE Multiple Spaces with One
Michael Meierruth (11/16/2009)
Nadrek (11/16/2009)
I didn't see it later on, but my solution in the past has been very simple; nest REPLACE() two spaces with one space as deep as required...- 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?
Bob Hovious 24601 (11/16/2009)
Did somebody say "googoo peanut clusters" ??
Didn't say it, but sure as heck implied it! 🙂
- 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: How to store spaces in an attribute?
Take a look at "ANSI_PADDING" in Books Online.
- 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: How to Query msdb for Failed Backups
I can't think of a way to do that directly, but you could certainly query that table and compare it to a calendar of when backups are supposed to be...
- 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: Surely It Should Just Work?
Elliott W (11/16/2009)
That was an amazing analogy G.. It is just perfect..CEWII
Thanks.
I view things from an evolutionary viewpoint, and that includes tools and ideas.
- 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: REPLACE Multiple Spaces with One
It's nice, but in this test, it loses by a large margin (on my desktop machine):
if object_id(N'tempdb..#T') is nullcreate table #T (
ID int identity primary key,
Col1 varchar(100));
if object_id(N'tempdb..#T2') is not...
- 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: Need correct data type
Yes. Depends on what you want.
For example, if it's been 1 hour and 30 minutes, are you looking for 1.30 or for 1.5?
- 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: license for mirroring
Per the Microsoft license, you can have a copy of Windows Server and SQL Server that's the same edition or lower than your production server, for a failover backup, so...
- 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 - 7,726 through 7,740 (of 14,953 total)