Viewing 15 posts - 226 through 240 (of 816 total)
print getdate()
print dateadd(m,-1,getdate())
print dateadd(m,-2,getdate())
.
.
.
.
.
.
and so on.
June 1, 2011 at 4:26 am
- transfer logins with http://support.microsoft.com/kb/246133
Sounds Good
- dettach the database from the old server and re-attach to the new ones
I will suggest to go with backup restore approach...
June 1, 2011 at 4:19 am
if you really want to play and learn then take this database in some test environment.
Modify the initialsize of database files(mdf and ldf) to 5mb(assuming your current database files...
May 31, 2011 at 5:02 am
So for this We need to cluster the windows server and then perform sqlserver cluster installation on it.Right!
Correct
1. Is Cluster disk ..............
For the rest of your question, please familiarise yourself...
May 31, 2011 at 4:42 am
I will say it depends on the frequency of IO on disk as TDE works only when data is moved from buffer pool to disk.
So yes it will have impact...
May 31, 2011 at 4:35 am
why tempdb is encrypted....
as you mentioned tempdb is used by all the databases so its being used by that database as well which is encrypted.
May 31, 2011 at 4:04 am
Cluster is not the sql functionality which windows used, its windows functinality which SQL server use.
May 31, 2011 at 3:17 am
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(200,'2011-02-30',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(400,'2010-02-30',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(400,'2011-02-30',2)
With this insert you will get error as The conversion of a varchar data type to a...
May 26, 2011 at 11:40 pm
use DB_ONE
go
select*
fromDB_ONE.some_schema.some_tablet1
joinDB_ONE.some_schema.other_tablet2on t1.id = t2.id
go
use DB_TWO
go
select*
fromDB_ONE.some_schema.some_tablet1
joinDB_ONE.some_schema.other_tablet2on t1.id = t2.id
What your execution plan report about these two different queries?
The actual query involved is more complex than what I have here, but...
May 26, 2011 at 11:04 pm
Turns out one of the analysts was inserting 27 million rows and doing a lot of sorting on non indexed columns. He finished his run and the data files returned...
May 26, 2011 at 4:19 am
Start with :-
1) use this query to get NoOfConnections in tempdb
(SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE db_name(dbid) = 'tempdb' GROUP BY dbid, loginame)
2) Sp_who2 and...
May 25, 2011 at 5:16 am
yes the issue is because by the time power is back, lot of transaction in queue in publisher which need to be updated in subscriber. And sometime there might be...
May 24, 2011 at 5:08 am
Logically if I have to filter the database name and then do the activity one by one in each database then cursor is the only option I can see here.
May 24, 2011 at 4:20 am
From all I have previously read I was under the impression that if the distributor is on a different server to the publisher then it takes the load of the...
May 24, 2011 at 4:11 am
this article will help in Reinitializing the Subscription :- http://msdn.microsoft.com/en-us/library/ms152466.aspx
May 24, 2011 at 4:03 am
Viewing 15 posts - 226 through 240 (of 816 total)