| |
| |
| |
|
Page: 1 2 3
Comments:
<0> wasabi: sorry, i was afk.
<0> i'm debugging an application and want to see how the db row changes (gets "filled") as i go along the many steps.
<0> the fields are changing all the time and i don't want to constantly fix the query.
<0> it's a very ad-hoc need, but i need it.
<1> Not following at all.
<2> what's the best way to package the execution of many sql scripts into one file?
<3> put them all in one file and run isql from the command line
<3> put the isql line in a batch file and schedule it
<4> can SQL 2005 replicate to SQL 2000 databases? Does it require compatibility mode 80 on your databases? Thanks.
<3> I heard yesterday someone on here saying they were doing 2005 to 200 replication, but he didn't say what compatibility mode it was
<4> interesting
<4> ill have to play around with it.
<5> will doing NOLOCK on selects help high transaction tables?
<1> Sure, it'll help you get inconsistant data.
<5> just trying to check if something exists
<6> is there a way to just move stored procedures from one database to the other?
<6> in mssql
<6> well, copy. not move :P
<3> EM "generate scripts" and run result on the other box
<7> if i want to add a bit of text to a column like (in a case) .... ELSE 'Phone:' + phone
<7> I get invalid data type
<7> do i need to cast the 'Phone :' part?
<5> convert it to a varchar
<7> ok
<5> is phone a varchar
<2> what"s the difference between using the sqlcmd and the isql from command prompt to execute a script?
<8> sqlcmd I believe supplants isql
<8> It has extra syntax for client-side scripting
<5> halo
<5> what's the best tool for SQL Proc tuning?
<8> A DBA?
<5> SQL Profiler?
<5> for me :)
<5> avg developer who also is a pseudo dba
<5> remember, we're a 2 man dev team here
<3> how about the age old analyze your queries as you go so you don't need tools later to figure out which queries are atrocious
<3> I found that "tool" works rather well
<5> and what is t hat
<3> so many people do DEV-DEV-DEV-DEV-DEV-ok now that were having problems in production lets 'tune the database'
<3> query analyser...actually hit the 'analysis' button and see the execution plan
<3> id you see tables scans...BAAAADDDD
<3> write indexes
<3> do this for ever query you write
<3> as you write them
<3> a query cost of over 1 (maybe 10 for reports) means you don't know what your doing and are swamping DB resources because of it
<5> ok, from inside Embarcadero, where do i get to SQL Profiler?
<5> oh crap, Oracle only
<3> you have db artisan?
<3> look up in the help section for 'show plan'
<3> thats a great tool, and damned expensive these days
<4> with sp_addlogin it was possible to p*** the login name in as a variable, can this be done with SQL 2005's alter user statement? I'm having trouble so far
<4> ALTER LOGIN @SecUserId WITH P***WORD = 'test', CHECK_EXPIRATION = OFF
<9> Anyone have a function for MS SQL to return first date and the last date of a month?
<9> i mean the first and last day
<10> first day is always 1 right?
<9> yes..hehe
<9> so, the last day
<10> last day is always first day of the next month minus 1 right?
<9> yes
<8> SET @FirstDay = DATEADD(DAY, -DATEPART(DAY, { fn CURDATE() }) + 1, { fn CURDATE() }); SET @LastDay = DATEADD(DAY, -1, DATEADD(MONTH, 1, @FirstDay));
<9> thanks so much halo
<7> yeah thanks
<11> hi, i need to scroll through a table of records 1 by 1 on the site, order is based on whatever goes into the WHERE part of the query so IDs are mixed up; my question is, how do i get the previous and next IDs from the result set, without having to pull ALL ids up to the record of this page and check prev/next that way; is there a better way? (using mysql, perl if that matters)
<12> limit 1
<12> select * from table where idcolumn > someID limit 1
<12> does @@rowcount work for delete statements in MSSQL 2k?
<12> hmm apparently it does, thanks guys
Return to
#sql
or
Go to some related
logs:
#gentoo
#freebsd
#beginner
#c
#visualbasic
janeydorr
#dsl
#asp
dacahard
#computers
|
|