Viewing 15 posts - 226 through 240 (of 351 total)
As Jeferey said
excessive use of ISNULL,
Checking for NULLS and not replcing or doing nothing with it.
AS use said parallelism
Use maxdop(1) -query hint and run --> might be helpful.
What...
April 12, 2011 at 4:49 pm
when the login is dropped the db owner will be null but still accessable to every one who have access to it. But there are scenarions where it restricts to...
April 12, 2011 at 4:28 pm
If you are the sysadmin
If you can login with the sa account
Then
Try SELECT IS_SRVROLEMEMBER('sysadmin');
If returns 1 then Yeah that is an sysadmin account.
April 4, 2011 at 4:30 pm
views can be accessed I Guess with any privilages.
March 30, 2011 at 12:54 pm
"SQL instance purchased and running out in the "cloud" somewhere."
As you said its in the cloud
The below link would help ful for you I guess to manage your server.
February 8, 2011 at 12:17 pm
right click on the table> columns> you can see the size of the datatype or properties of columns. if you are looking to find only two or limited columns
February 8, 2011 at 12:04 pm
What do you mean?
are you asking whether you can install sql 2008 on vmware for high availability.
or Is Vmware supports high availability?
February 8, 2011 at 12:01 pm
In first, I don't think you can reference country id in userinfo table as foriegn key as it is not a composite key or unique key or not not part...
February 8, 2011 at 11:31 am
If you are using sql server 2008
in that case go to
windows>sql server 2008> configuration manager> right click sql server agent> enable or start
set automatic to start evry time you...
February 8, 2011 at 11:10 am
I think the code nam edenali is sql server 2011 I guess not sql 2010.
February 8, 2011 at 11:07 am
Steps you need to do for each table as far as I know
drop clustered index on the table
create dummy clustred index
the new clustred index won't use your partion scheme so...
February 7, 2011 at 4:48 pm
Use Replication and elect your tables to replicate with the live data.
if you don't want to update some tables.
February 7, 2011 at 4:35 pm
As you said he owns the job he should be able to see that job under SQL Agent
Tell him rihgt click on the job> view history
Where it dispalys information.
also...
February 7, 2011 at 4:10 pm
You will get error obviously because
partition function is used by table and scheme is uses of function
follow this link for detail all steps here
So the correct way to...
February 7, 2011 at 3:48 pm
If the month is january then how can we display previous month?
use datediff(dd,date,value) function
February 1, 2011 at 1:28 pm
Viewing 15 posts - 226 through 240 (of 351 total)