|
|
-
Hardik Doshi Commented 1 Years ago through Just Learned | 1 Point
When SQL Server restarts, DMV & DMFs are reinitialized so query will not return proper data. We can use this query if we are sure about SQL Server restart....
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
MSDN link for more information: [sysmail_delete_mailitems_sp][1]
[1]: http://msdn.microsoft.com/en-us/library/ms190293.aspx...
|
|
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
Right. At first glance, we may not able to check the issue so we can check the available databases by executing:
select name from sys.databases...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
Suppose I have database structure like:
/****** Object: ForeignKey [FK_EmployeeDetails_Employee] Script Date: 11/10/2011 10:03:09 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_EmployeeDetails_...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
Is there any way to disable the same on the server where we deploy the reports without manual step?...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
You can use **"sp_MSforeachtable"** procedure for the same. But keep in mind that it is undocumented stored procedure.
Query is like:
EXEC sp_MSforeachtable N'drop table ?'
If you want to retrieve record counts for all the database tables, ...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
I know {fn now()} and {fn current_date()} but I don't know others.
You can also refer: http://blog.sqlauthority.com/2007/06/21/sql-server-retrieve-current-date-time-in-sql-server-current_timestamp-getdate-fn-now/...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
Alpesh, I don't agree with your wordings.
Which one is better to use index on table or not? Simple answer is for Small table no and for table with huge data yes.
Answer is: It **Depends**
If you have large database table and column is not used...
|
-
Hardik Doshi Commented 2 Years ago through Just Learned | 1 Point
Please share the document/blog/tip link for more details....
|