Viewing 15 posts - 2,161 through 2,175 (of 2,462 total)
moosamca (2/22/2010)
In a datbase, i need to find what are all the master tables and what are the transactional tables.
What i got from other posts and your query is,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 6:06 am
Here DB stands for "DOMAIN" and XXX stands for my profile name . is there any chance that
login and user can be different ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 5:33 am
If we are backing up the TLog.
Will it reclaim the space ?
cant we use DBCC shrinkfile option to regain the space ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 5:21 am
Read below posts
http://www.akadia.com/services/sqlsrv_logins_and_users.html
http://www.sqlservercentral.com/articles/Administration/beginningsqlserverloginsandusers/1460/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 2:09 am
my guess is you are not getting
Db_size corectly as i think ramesh's query will return same size for both max and min.right ?
can u provide some sample data ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 24, 2010 at 1:54 am
declare @sql nvarchar (200), @col varchar (100)
set @col = 'acct_id'
SET @SQL = 'SELECT acct_num FROM account where ' + @COL + ' = 1000'
print @SQL
EXEC(@SQL)
see above example...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 23, 2010 at 7:42 am
sanketahir1985 (2/23/2010)
record for max(dbdate) & min (dbDate) for each database
can you elaborate min and max ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 23, 2010 at 7:37 am
First , Are you using sql 2008 ?
and second thing ( blind guess) use sa(administrator) account to run it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 5:43 am
Why you want to skip empty file
i dont think there is any point to keep them ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 2:31 am
the error posted by you bascially general info , we get in may job failure
post the complete error and what you are trying to do in that...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 2:22 am
try sp_readerrorlog
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 1:09 am
Tell me what you are doing in that plan
have you migrated it from other location ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 1:08 am
sumitkumar.agrawal (2/18/2010)
hey Shriji,So we have this book's softcopy somewhere ??
Find eBooks Here
http://www.red-gate.com/about/book_store/index.htm
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 1:06 am
Try this
declare @tbl table ( logdate datetime, processinfo nvarchar(20), login_text nvarchar(max))
insert into @tbl (logdate, processinfo, login_text)
exec sp_readerrorlog
select * , '[' + SUBSTRING( login_text , PATINDEX ( '%CLIENT:%', login_text)+7,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 12:58 am
Paul nice example
but if the table is heavy transactional table and we have indexed view on that and then clustered index on it.
Will it improve the performance?
which...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 17, 2010 at 5:53 am
Viewing 15 posts - 2,161 through 2,175 (of 2,462 total)