Viewing 15 posts - 391 through 405 (of 860 total)
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10%5B1%5D.pdf
The OP was talking about Windows Server not SQL Server being the limiting factor the link...
April 30, 2012 at 2:05 pm
mwaniki1 (4/27/2012)
April 27, 2012 at 6:22 pm
rraja (4/27/2012)
By modifying the log file directory wont create any issue. here is the steps.
from the OP's response it sounds as though existing databases are staying right where they...
April 27, 2012 at 5:59 pm
L' Eomot Inversé (4/27/2012)
Lynn Pettis (4/27/2012)
L' Eomot Inversé (4/27/2012)
GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?
Yup.
On the plus side, SQL's smart enough not...
April 27, 2012 at 3:04 pm
ColdCoffee (4/27/2012)
Sean Lange (4/27/2012)
ColdCoffee (4/27/2012)
Sean Lange (4/27/2012)
April 27, 2012 at 3:02 pm
Lynn Pettis (4/27/2012)
April 27, 2012 at 2:55 pm
SQLRNNR (4/27/2012)
EL Jerry (4/27/2012)
Lynn Pettis (4/26/2012)
Freedom!Wallace?
Gromit
tie down
April 27, 2012 at 2:36 pm
take a look at Jeff's text splitter. i think it will be close enough to what you need it will get you a big push to the finish line...
April 27, 2012 at 1:55 pm
riya_dave (4/27/2012)
but without it i am getting data into seconds ,and with it its running more than 7 minutes ,still not getting data
what happens when you run just the procedure...
April 27, 2012 at 1:41 pm
If the OP does not have a tally table in there DB they can use the following to create one on the fly with out hitting sys.columns.
;WITH e1(n) AS (SELECT...
April 27, 2012 at 12:28 pm
paradski (4/27/2012)
April 27, 2012 at 12:21 pm
Sean Lange (4/26/2012)
jwbart06 (7/26/2011)
I was trying to think of doing it with out having to rely on sys.columns, but I can...
April 27, 2012 at 11:27 am
you can but as lynn said make sure you are returning 4 columns. i would also explicitly define the order (INSERT INTO bla (id,col1,col2) ...) get rid of...
April 27, 2012 at 9:09 am
dwain.c (4/26/2012)
Anyone want to tackle a semi-complex reporting / accounting issue?
http://www.sqlservercentral.com/Forums/Topic1290025-1291-1.aspx#bm1290373
My...
April 26, 2012 at 7:06 pm
have fun learning the new product. did your company decide to switch from the {extreme sarcasm} evil closed source model to the wonderful sent from heaven open source free...
April 26, 2012 at 5:52 pm
Viewing 15 posts - 391 through 405 (of 860 total)