Viewing 15 posts - 166 through 180 (of 337 total)
GilaMonster (1/2/2012)
Forwarding pointers are only found in heaps (so there can't be any in the NC index) and they seldom make the table much larger than it would be without.
Also...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 2:47 am
After running updatusage I get the following
DBCC UPDATEUSAGE: counts updated for table 'Tbl_FaoTrades' (index 'IDX_TD_LOGINID_TD_DATE', partition 1):
USED pages (In-row Data): changed from...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 2:36 am
Asked here also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169550
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 25, 2011 at 8:57 pm
Perry Whittle (12/22/2011)
opc.three (12/22/2011)
Sure...but how would you copy the file (without xp_cmdshell)?Via a VB script ran as a SQL agent job step!
Not sure..But cant we just take SQL totally out...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 22, 2011 at 9:04 pm
Cant you just write a 4 line code VBscript in a batch file to create a folder and schedule it using windows scheduler ?
Something like this
Dim folder
folder= "Yourpath"
set objFSO...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 22, 2011 at 1:29 am
Yes it is a know bug.
What you can do is open a new instance of SSMS in a new window and the edit the same job and it will work...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 18, 2011 at 9:10 pm
Maybe you can go for a certificate based authentication where you create users from a certificate in database A and then create a SP in database B which executes a...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 17, 2011 at 11:21 pm
I wouldnt worry about fragementation for indexes having less than 1000 pages.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
November 2, 2011 at 1:59 am
sqlnaive (10/17/2011)
Execute permissions denied. I am checking again with giving view definition permission on the database.
Run this and try
Grant Execute to Win_Read
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 17, 2011 at 5:38 am
Ok maybe snapshots were not such a good idea.
How about setting up LogShipping (if latency is accepatable) or snapshot replication ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 17, 2011 at 3:25 am
sqlnaive (10/14/2011)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 17, 2011 at 1:27 am
gary.dunn (10/13/2011)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
October 17, 2011 at 1:18 am
sqlbuddy123 (9/13/2011)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
September 15, 2011 at 1:42 am
Thanks for the reply Ashish.
The client needs a separate reporting database for each OLTP DB.So if he has 350 DB's he wants 350 reporting databases each containing 20000 tables(not sure...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
September 12, 2011 at 11:58 pm
How about using the intersect operator ?
DECLARE @a int = 123,
@b-2 int = 123 ,
...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 16, 2011 at 4:07 am
Viewing 15 posts - 166 through 180 (of 337 total)