Viewing 15 posts - 226 through 240 (of 405 total)
As jan van asked why are you using nvarchar
You must have noticed that in your result some numbers are missing . This is actually charactor comparison.
If you want the correct...
October 10, 2012 at 5:52 am
Great article. Very useful for DBA in production environment.
September 27, 2012 at 2:12 am
Thank you for the wonderful article.
Looking forward to hear more on performance
July 11, 2012 at 12:21 am
Conceptually both are same.
Login lets you connects to the server
and User has the permissions inside the database.
Only difference is in 2000 the user and schema are clubbed.
In 2005 they are...
July 9, 2012 at 3:14 am
SELECT o.Name as TableName,
i.rowcnt Row_count,
c.Name as ColumnName,
t.name as DataType,
t.length as [DataLength],
c.collation
FROM sysobjects o
JOIN syscolumns c
ON o.id = c.id
JOIN systypes t
ON c.xtype = t.xtype
JOIN Sysindexes i
ON o.id=i.id
WHERE o.xtype = 'u'
and i.indid...
July 16, 2010 at 9:11 am
You can add a join to sysindexes and filter for clustered index or heap (indid in (0,1)
July 16, 2010 at 8:09 am
You can check the restorehistory in msdb database to conform the restore. View logs for the jobs
July 16, 2010 at 5:51 am
Hi,
How did you set up the log shipping , manually or wizard. Was the log applied on the secondary? what frequency is configured for the log to ship.
July 16, 2010 at 5:29 am
Graphic designer->Video editor-> then website developer->
.net developer
(all the above without much luck)
Finally SQL DBA for past 4 years. Happy everafter
April 19, 2010 at 7:58 am
It is possible for different nodes be patched differently.
April 19, 2010 at 7:47 am
Just see why you have that much unallocated space in files. Normally this much free space comes after some cleanups only (if it is data file). If it is not...
April 19, 2010 at 7:24 am
You can use xp_cmdshell.
xp_cmdshell 'sc qc mssqlserver'
Note: xp_cmdshell makes your server vurnerable to threats. Disable it once you are done
April 19, 2010 at 6:24 am
Viewing 15 posts - 226 through 240 (of 405 total)