Viewing 15 posts - 6,481 through 6,495 (of 7,168 total)
It could be ANSI_WARNINGS or ARITHABORT.
ANSI_WARNINGS and ARITHABORT are both ON for new query windows in SSMS 2008 R2 by default which DOES allow Divide By Zero errors to bubble...
May 11, 2011 at 6:48 am
PS Be careful with using the XML RAW method as well...it escapes characters like ampersands and angle brackets to their XML-safe equivalents (namely & , < and >) so...
May 11, 2011 at 6:10 am
Jason, your solution, while it may produce the correct result, will inevitably perform very poorly when run against a large set of data. I would offer one tweak to trade...
May 11, 2011 at 6:07 am
Rob Schripsema (5/10/2011)
You have relatively wide records with clustered indexes. If the order of the data in the clustering index fields...
May 10, 2011 at 4:50 pm
PHXHoward (5/10/2011)
I gave the row a name 'test' and then it ran.
It adds a new row for each application.
instanceid application
417row test=",Application1
417row test=",Application2
418row test=",Application3
instead of
417 ...
May 10, 2011 at 2:58 pm
armm1388 (5/10/2011)
but source bank is sqlserver 2000 and destination is sqlserver 2008.therefor by backup and restore . it can't be done . system give error.
what is the solution?
It can be...
May 10, 2011 at 2:36 pm
Yep, that works as well.
May 10, 2011 at 2:09 pm
Try this:
$dt | select-object Name,Version,ServicePack,Edition | Export-csv C:\DBAScripts\Test.csv -NoTypeInformation
May 10, 2011 at 11:11 am
Syed Jahanzaib Bin hassan (5/10/2011)
May 10, 2011 at 10:41 am
kr.nithin (5/5/2011)
The scenario is that I have got around 30 SP's to be executed & my manager wants me to create a single batch file for all the SP's. Please...
May 10, 2011 at 9:02 am
facticatech (5/10/2011)
- How many tables?
6 . Already mentioned.
You did, sorry I missed that.
facticatech (5/10/2011)
- How are the inserts being done? OLE DB destination, Calling a stored procedure for each...
May 10, 2011 at 6:56 am
freewarefw (5/10/2011)
here the order of execution :
1)-run file migrate_all.cmd that execute the command :
call CheckSQLVersion %1 %2 %3 %4 %5
@if %errorlevel%...
May 10, 2011 at 6:45 am
I was just researching Median on SQL Server last week. Here is a good series of articles from some very qualified folks where a back-and-forth discussion broke out on the...
May 9, 2011 at 9:45 pm
apat (9/10/2010)
select group_concat (Col1 order by field(Col2,8,13,15,53,55,6,73)) as FinalColumn from TestTable
Are you sure that's your SQL statement on MySQL? GROUP_CONCAT is an aggregate function so the SELECT statement that makes...
May 9, 2011 at 9:36 pm
You will have to provide a lot more detail before anyone will be able to provide a solid recommendation on how to improve your situation.
Here are some initial questions...
May 9, 2011 at 1:52 pm
Viewing 15 posts - 6,481 through 6,495 (of 7,168 total)