|
|
-
Hemantgiri S. Goswami Replied 12 Months ago through ASK | 1 Point
If I recall correctly, you can use UNICODE data type for multilanguage support, refer http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx and http://www.sqlservercentral.com/articles/Miscellaneous/globilizationinsqlserver/1946/
hth
Hemantgi...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 12 Months ago through ASK | 1 Point
Mustaq,
Let us take an example of here, suppose you are writing a book - 100 pages book. While writing a book you are asked to skip 3~4 lines on each page, at the end you may have skip total 15~20 pages. That mean, the book is 80~85% full.
In simpl...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 12 Months ago through ASK | 1 Point
Nirav,
You may also refer the article I have published year ago http://www.sql-server-performance.com/2010/sql-server-upgrade-issues/
hth...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 12 Months ago through ASK | 1 Point
Hi,
To best of my knowledge you can use UNICODE datatype for this.
Sorry was too busy to revisit this forums since month....
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 1 Years ago through ASK | 1 Point
Anil,
Assuming you have SQL Server 2005 or above, try as below :
SELECT
top 5
kpid,lastwaittype,PROGRAM_NAME,
ROW_NUMBER() OVER (
ORDER BY lastwaittype) AS 'Row Number'
from master..sysprocesses
order by 'Row Number' DESC...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 1 Years ago through ASK | 1 Point
Hi,
Log Shipping:
Threshold are the values that we have configured to send us an alert, i.e. if log backup is not applied to secondary server for 120 minutes please alert me on some@email.com ; now there may be many reasons for this like :
1) There ...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 2 Years ago through ASK | 1 Point
Apart from the things that Sankar mentioned, you may want to check if there are high tempb activity like sorting in tempdb- online index rebuild job, or other tempdb activities like creating staging tables and filling up data into table with bulk inserts e...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 2 Years ago through ASK | 1 Point
Krishnakant can you please rephrase your question...
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 2 Years ago through ASK | 1 Point
Mohammed,
DId you through the installation? Did you try installing with the default administrator account (by enabling it ) ? Also ensure that the user under which security context you are performing installation has all the required sets of permission....
![]()
|
0
·
0% ·
0
|
|
-
Hemantgiri S. Goswami Replied 2 Years ago through ASK | 1 Point
A very quick check, by any chance are you running this installation as standard user? Actually in Windows 7, the defauly administrator account is disabled and one need to enable this account. So do try installing the SQL Server by logging default administr...
![]()
|
0
·
0% ·
0
|
|