Forum Replies Created
Viewing 15 posts - 376 through 390 (of 14,953 total)
-
RE: intellisense not working
Weird. I guess I'd be poking around in settings if it were me. But sounds like you've already done that.
Call Microsoft? Should have some free support tickets...
- 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: Select only mismatching column NEED HELP !
Cool biz.
- 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: Exporting a TEXT (or long varchar) column to an Excel file with the OPENROWSET command.
Not sure what you mean about SSIS not being able to do a "dynamic command string". It can do dynamic connections, and dynamic queries.
But the main thing you're running...
- 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: intellisense not working
What version of SQL Server is your database on, and what compatibility level is the database? Native SSMS intellisense is affected by that, if I remember correctly. (I...
- 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: Select only mismatching column NEED HELP !
Whatever works for you. As mentioned, they've all got pros and cons.
Edit: So far as I know, CDC doesn't use any triggers. It's basically just an automated log-parser....
- 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: bulk insert blocks nolock query
GilaMonster (12/13/2012)
GSquared (12/13/2012)
Sch-M locks are schema locks. Means you can't change the definition of the table during the bulk insert.Sch-M is a schema modification lock. Taken by...
- 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: intellisense not working
Not clear on one thing: Intellisense in Visual Studio, or Intellisense in SQL Server Management Studio?
- 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: Icons and what it means ...
Another thing I find useful in SSMS, is use the Tools->Options->Environment, to change from "Tabbed documents", to "MDI environment".
Then you get individual "windows" for each connection, and you can see...
- 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: Icons and what it means ...
The green icons mean SSMS can tell that the SQL Server service is running. White means it doesn't have access to that data, so it's not sure.
Connections don't change...
- 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: When AutoShrink will occur in SQL server 2008?
Autoshrink will shrink the database when there's 25% space available, per http://msdn.microsoft.com/en-us/library/bb522682.aspx.
But it's almost always a really, really, really bad idea to turn on autoshrink.
You can also schedule a database/file...
- 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: bulk insert blocks nolock query
Sch-M locks are schema locks. Means you can't change the definition of the table during the bulk insert. Might mess the whole thing up if you were to...
- 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: Why left join is not giving distinct result?
I don't have access to your database, so all I can say here is that the query is doing what you're telling it to. You just have a different...
- 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?
I just noticed something. Doesn't mean it's new, just means I just noticed it.
Per the standings page (http://www.sqlservercentral.com/TotalScores), I'm still listed as "SSChampion", just like everyone else with serious...
- 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: Select only mismatching column NEED HELP !
Ah. Audit trails.
CDC will work for that. There are a number of other options, each with its own pros and cons.
I generally prefer to use triggers that capture...
- 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: Using Find and Replace with Regular Expressions to match one word and exclude another
I don't think that's a regex issue. Wouldn't you just use a find with a "and not" in it? Find anything with CREATE, and not with the regex...
- 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 - 376 through 390 (of 14,953 total)