Viewing 15 posts - 391 through 405 (of 644 total)
Phil Parkin (2/17/2012)
VARCHAR takes 1 byte space (on disk) to store 1 character whereas NVARCHAR takes 2 byte space (again on disk) to store 1 character.
This is not quite...
February 17, 2012 at 8:41 am
gantavasu (2/17/2012)
How to fix the orphaned users problem in sql server 2008.
It seems you are asking it for some interview preparation from the way you are asking it 😉
Please...
February 17, 2012 at 8:38 am
jasonmorris (2/17/2012)
People still use xp_cmdshell :w00t:
Why not, this is the one that has served us for years & has been exceptional for a DBA in handling things like that :Whistling:.
February 17, 2012 at 8:24 am
Anamika (2/17/2012)
while changing the varchar to nvarchar on my tables to support unicode, do i have to increase the size of the datatype?
for example to change varchar(40) if i change...
February 17, 2012 at 8:17 am
mohan.bndr (2/17/2012)
February 17, 2012 at 7:59 am
pallavi.unde (2/17/2012)
I am tried for below ,
where primary key should be in A101,A102
Order No Date Product Qty Customer Batch No
A101 10-Oct-2010 Mac Book 03 John B01
A102...
February 17, 2012 at 6:13 am
kranthi.india123 (2/17/2012)
Thank you,You are saying right,but My scenario i can use TRUNCATEONLY Option on logshipping databases,there is mismatch of LSN's ,i.e., main problem LSN's Mismatch
I would suggest to always use...
February 17, 2012 at 5:14 am
kranthi.india123 (2/17/2012)
DBCC SHRINKDATABASE(N'LearningCT', 10, NOTRUNCATE)
NOTRUNCATE does not return the released free space to operating system & physical size of the file will remain same on the disk. So why do...
February 17, 2012 at 4:06 am
1. If you want an auto generated column for your table then you can use IDENTITY property.
CREATE TABLE TestTable
(
IDColumn INT IDENTITY(1,1),
DataColumn1 VARCHAR(20),
DataColumn2 VARCHAR(20)
)
2. If you want to generate sequence numbers...
February 17, 2012 at 3:28 am
mohan.bndr (2/17/2012)
I executed the query below ...
DBCC SHRINKFILE ('tempdev', 1024)
eventhough I didn't get free space...
February 17, 2012 at 3:06 am
mohan.bndr (2/17/2012)
February 17, 2012 at 2:44 am
kranthi.india123 (2/16/2012)
Configured log shipping--SuccessFully working.
so My qustions is?
If i shrink primary database it will affect log shipping?
If i shrink mdf it will affect log shipping?
If i shrink...
February 17, 2012 at 2:32 am
It is there for reusability. Using the variable is to ensure that the value will not be changed during the execution of the batch (if it is the requirement of...
February 16, 2012 at 6:31 am
Viewing 15 posts - 391 through 405 (of 644 total)