Viewing 15 posts - 181 through 195 (of 1,179 total)
If you are planning to install it on your laptop or personal machine and exclusively used for development you can think of HYPER-V too it help to rebuild the environment...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:59 pm
As you have mention that renaming the stored procedure works fine. Based on this info you can try executing stored procedure with recompile option every time and see if you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:53 pm
What will be size of Analytic databases? As clound is having some limitations handeling large database in cloud.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:43 pm
How about creating seperate table for SSN and DOB having FK reference as empid? After that these two column can be encrypted. The purpose of creating this table is you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:41 pm
Can you try running services under local system account?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:17 pm
Easy one, thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2014 at 11:11 pm
Provide more details about function. What kind of function it is? What it is doing? How it is connecting to the database? etc.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 15, 2014 at 6:30 am
SQL Server 2012 support hetrogeneous replication for Oracle Subscriber. SQL supports push subscriptions to Oracle.
Install and configure Oracle client networking software and ORACLE OLE DB on the SQL Server Distributor,...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 15, 2014 at 12:35 am
I am also bit confused; after the upgrade it says db is in 110 compatibility i.e.SQL 2012 while 9481 trace flag will force the query optimizer to use version 70...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 15, 2014 at 12:19 am
Yes, it is possible but slitly different than SQL 2005. Refer following link for further details:
http://databasebestpractices.com/edition-upgrade-sql-server-2008-r2-express-standard-edition/
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 14, 2014 at 5:35 am
Yes, droping and readding after the data load is faster.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 14, 2014 at 5:26 am
It also depends on what kind of information are you capturing in your trace file? What are the counters have you opted in your trace? You can also use filter...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 14, 2014 at 1:15 am
Sometime it is good to have patience as mention by Gail.
What is the database size? Since howlong it is in recovery?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 14, 2014 at 1:09 am
Good one, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 14, 2014 at 1:04 am
Nice question, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 13, 2014 at 11:16 pm
Viewing 15 posts - 181 through 195 (of 1,179 total)