Viewing 15 posts - 13,876 through 13,890 (of 26,486 total)
Am I wrong or is this a PeopleSoft database?
March 7, 2012 at 8:03 pm
Take a look at the permisions service account under security for the server. It sounds like it may have sysadmin privledges which means it doesn't have to be a...
March 7, 2012 at 6:59 pm
The current max setting is 2 TB. SQL Server could potentially starve the OS. You really do need to change that setting. Depending on what other software...
March 7, 2012 at 6:48 pm
How about the DDL for the table, some sample data, the expected results, and what you have done so far to solve your problem.
March 7, 2012 at 6:41 pm
You really need to explain how the source is supposed to be transformed into the destination. I have looked at your spreadsheet and the data and I can't see...
March 7, 2012 at 6:40 pm
GilaMonster (2/21/2012)
EL Jerry (2/21/2012)
In your experience, how often have you seen DBs with Bulk-Logged recovery models and what are they used for?
A couple, but I suspect that was due to...
March 7, 2012 at 5:06 pm
Just so you know, you need to pivot the data at some point. You could use a split function on the string, but you will find that you are...
March 7, 2012 at 8:00 am
vijayangk (3/7/2012)
1st one has the table name and the second column has all the column names with comma separator
TableName | col1,col2, col3,........
March 7, 2012 at 7:54 am
SKYBVI (3/7/2012)
I dont think DDL is needed and sample data i already put..Leave the question if u can't help.
This response is unprofessional. If you want our help, you need...
March 7, 2012 at 7:45 am
Would be nice if you'd share what the problem was and how you solved it.
It may help others who may have the same or similar problem.
March 6, 2012 at 11:59 pm
chandarcst (3/6/2012)
Now only I started to work
You have a long way to go. I have been working with SQL Server for almost 15 years and I still learn new...
March 6, 2012 at 11:56 pm
Not sure if we can. Just running your code the two tables have different data.
#temp2:
a3a4aum
12100
31200
23100
210500
35200
1029100
#AUM_Raw_Upload1:
CHILDACCOUNT1PARENTACCOUNT1CHILDACCOUNT2PARENTACCOUNT2a3a4aum
1 NULL ...
March 6, 2012 at 11:44 pm
Jeff Moden (3/6/2012)
You added "IO" to the mix, Lynn. Probably not a bad thing to do. The "Physical Reads" are a bit ironic.
Yes, yes I did.
It was interesting....
March 6, 2012 at 11:30 pm
Ran Jeff's tests on my PC at home, it is only 7 years old and has a hyperthreaded processor. Here are my results:
========== Siva Method =================================================
DBCC execution completed. If...
March 6, 2012 at 11:11 pm
cvyc06 (3/6/2012)
Which reminds me of the time I learned the true meaning of 100%.
A friend of mine ran a boning plant...
March 6, 2012 at 10:51 pm
Viewing 15 posts - 13,876 through 13,890 (of 26,486 total)