| |
| |
| |
|
Page: 1 2 3
Comments:
<0> what the **** does "Suspect" next to my database in sql server management studio
<0> mean
<0> Its something that just cropped up
<0> I was inputting a HUGE ammount of data
<0> 7.8gb or so
<1> Means you broked it. Check Event Viewer status and progress of any recovery operation.
<1> Kick out the power cord?
<2> does anyone know of a better tool than the query analyzer that comes with mssql2k for just doing basic query stuff?
<3> BoostedV8: look at some of the free ones (cough mysql) then you can put "better" in perspective
<1> Better as in how?
<2> Oh I know all about some of the free crap, even commercial ones can be crappy
<4> I dont see **** in event viewer about recovery etc
<3> ohh k. thats different then, I'll shuttup :P
<4> or any errors for tha tmatte
<2> will the 2005 tools work with 2k?
<3> yes
<2> I had them on one of my home machines and liked them
<4> to some extent
<3> ms says thats the preferred way to do it.
<3> in a mixed environment
<2> Ok well I'll probably run thoes then.
<3> ron_frown: did the it take a **** while trying to grow the db?
<3> take a **** = run out of space.
<4> 48gb free
<4> ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
<4> SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
<4> terminating this process.
<3> um, this might sound wildly strange but - is 48gb less than 10% of the current size of one of the files?
<3> er oh. looks like something weirder
<4> how can I recover schema if I need to
<4> I can get the databack no problem
<3> you can probably find a walkthrough on the net for resetting the status
<3> i've been in a position where ive had to do that before though, and ended up having a tech at ms walk me through something strikingly similar (the difference being, that it worked.. )
<5> dbcc checkdb
<3> wont work on a suspect db
<6> ok, union worked... but I'm having trouble figuring out how to make the NULL ID's show up at the bottom (basically I want one select statement's values to all show up first, then the select statement that returns the null ID's after that)
<7> so i've been using QA to profile some large queries of mine and i noticed that one of the more expensive operations is where i select a single row from a config table which only contains one row. Would I be better off adding a PK to and just "where A=1" or is there some other best practice for this kind of thing
<3> cuebix: add a static value/column to each select and order by it
<3> maybe.
<6> ah, smart!
<6> that worked perfectly, thanks!
<3> :D
<6> doh, lol, well, it works great as a stand-alone query, but when I use it as a definition for a view, I guess it throws away the order by stuff
<3> ooohh yea.. it wont like that
<6> hmmm
<6> I guess I'll include that static number in the output of the view and order by it in my query against the view
<3> is this statement currently sorted by the column with the null values in question?
<6> not explicitly
<6> but yeah, it seems to be doing it implicitly
<8> to hell with ruby, python is great
<9> if i copied a DTS package from one server to another one it is still linked ot the old database. I want to link it to the new database anme
<9> FYI SQL 2000
<9> i can edit the connections the are all pointing to the new database
<8> hoh did you do that?
<8> how did you do that?
<8> copy DTS packages from one server to another?
<9> packace > save as
<9> package > save as
<8> to another server
<9> yep
<9> but the DTS package is still refrencig the old db
<8> yeah, you'll have to change that stuff manually
<9> i have in all the connections
<8> and it still does it?
<9> but somethign is still refrencing the old db
<9> every step fails saying it cant find the db
<8> well you didn't change thwm all then did you
<9> is there a main DB that the DTS package is connected to
<8> nope
<9> there are only 2 connections
<8> thats why you build packages using (local)
<8> as much as possible
<8> look at the code inside the packages, there must be something there hard coded to the old server
<10> how do select something that shouldn't be case sensitive , ie select * from bla where username = any case of this username ?
<8> lcase(username)='myuser'
<10> what if the username is MyUser ?
<10> it won't match
<8> lower(usernname)=lower('MyUser')
<8> comon man, this ain't rocket science here
<11> loef, what database?
<10> mysql
<11> goto #mysql
<8> oh well
<8> have fun
<12> mysql prolly matches it even if you use = :P
<8> I think they outta rename it to myrandomlylostdata
<10> Jarett_: i am in mysql
<8> myrandomlylostdata or myhorribleblogdb
<11> loef, the #mysql chat... since it isnt supported here
<8> weblog munchers annonymous
<10> Jarett_: where does it say?
<10> erf
<8> I'm starting to hear that postgres ain't much better
<10> everyone hates mysql in here? :P
<8> ...but it's 3 times faster than sybase,oracle and microsoft!
<8> acedemia is still trying to make a real relational database
<11> loef, by default mysql shouldnt be case sensitive. it spends how the db was setup...
<12> yeah, especially COUNT(*) in postgres is exceptionally fast
<8> hehehe
<8> yeah it's bad when can you grep count the datafile before the count(*) comes back
<13> Hello, Can someone please explain to me what is the deal with the dates in SQL Query Language, when i do #00/00/0000#, it take it as mmddyyyy, why and how can i use ddmmyyyyy ?
<14> read about the datepart command
<11> Lagged__, change your environment settings or read on the specifics for the database
<13> Jarett_ : ohh. so Once a DB is created a setting is declared for that ?
<11> Lagged__, yes
<13> Jarett_
<13> Thanks :)
<13> i'll search on that
<11> what database?
<2> are the mssql 2000 tools a free download or do i have to have a sql server media copy?
<11> 2000 werent i dont think
<3> free download was msde w/ no tools
<3> 180day eval was (is?) a download that has the tools
<3> for free*
<15> Anyone in here with experience in merge replication in MSSQL Server 2005 Mobile?
<8> good gawd, if that were wine I'd have you shot for opening the bottle to early
<3> lool
<8> I think a better question would be, has anyone got any kind of replication going on M$ product and gotten sleep at the same time
<3> ido..
<3> but im a push recipient.. soooo
<3> its not really *me*..
<8> hey well,
<8> you've seen it work
<3> yea, we do 2k5 to 2k now and it works swimingly
<3> but its transactions for a data warehouse, I don't know that anyone would actually know if something was missing
<8> yeah it always seemed fragile at best
<16> Hey guys, I'm having a problem having sqlite_escape_string properly escape things. I have a simple form to save a note to an sqlite db, and if the input has single or double quotes, it will error out on the quer
<16> y
<17> sounds like a php problem
<16> hrm..
<16> PHP Version 5.1.2 wonder what the latest version is
<16> Say I insert, Dog's like food. After running sqlite_escape_string it returns UPDATE members SET notes="Dog''s like food." WHERE ID= 4
<17> how are you writing your insert?
<17> its doing what you are asking sqlite_escape_string() will correctly quote the string specified by item for use in an SQLite SQL statement. This includes doubling up single-quote characters (')
<16> http://sql-servers.com/nopaste/?show=712
<16> hmm
<17> why are you using " instead of ' for your value?
<16> if I try to insert Dog's like "food". it echos UPDATE members SET notes="Dog''s like "food"." it renders, Error in query: SQL logic error or missing database
<16> CoJoNEs, no reason :\ trying to learn
<16> didn't mean to double paste lines 2 and 3 also
<17> update members set notes = 'Dog''s like "food"'
<17> thats two single quotes between g and s
<16> Thats what needs to be typed in the form?
<17> thats what an update statement needs to look like
<17> sqlite_escape_string() will change Dog's to Dog''s
<16> Is there any way around that?
<17> around what?
<17> its doing what its supposed to
<14> uhmmm why won't SQL 2005 upgrade a SQL 2000 SP4 instance??
<17> justinm I dunno, why?
<18> I have a dblist of matches, two teams. how can I get a spesified number of matches from one team?
Return to
#sql
or
Go to some related
logs:
#microsoft
cloning a drive with dump fc4
kban
#windows
drkrose
tablet pc regular wacom pen
#goal
#windows
#nhl
#fedora
|
|