|
|
-
Chintak Chhapia Commented 4 Months ago through Blogs
Yes, constraints as well as indexes will not be available in new table. For more information have a look at limits and restrictions [here][1]. Also, rowversions gets copied.
[1]: http://msdn.microsoft.com/en-us/library/ms188029.aspx...
|
|
|
|
|
-
Chintak Chhapia Commented 4 Months ago through Blogs
SSMS grid is very slow in processing/ displaying data, to reduce the load we can discard the results....
|
-
Chintak Chhapia Liked 4 Months ago through Blogs
Sometime we feel that a query in application is quite fast while same query is relatively slow in SQL Server Management Studio. Why So....
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
Are your SQL Server instances up-to-date? Use official SQL Server Build lists to know about the latest releases of SQL Server....
|
|
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
SQL Server has the ability to enforce organzational security policies for SQL login passwords. This can be bypassed by using the CHECK_POLICY clause in the CREATE LOGIN statement. However, when using hashed passwords, no such restrictions seem to apply....
|
-
Chintak Chhapia Learned 5 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Chintak Chhapia Liked 5 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|