|
|
-
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
-
Manoj Bhadiyadra Commented 9 Months ago through Just Learned
If you are not interested in seeing all logs , and interested in last entry only, i mean who has modified object last, then
i think SYS.OBJECTS is the best option to go with....
|
-
Manoj Bhadiyadra Posted 11 Months ago through Blogs
Used to compare the data in two tables for non-convergence, which is useful in a replication topology. syntax for this utility is: tablediff [ -? ] | { -sourceserver source_server_name[\instance_name] -sourcedatabase source_database ...
|
-
Manoj Bhadiyadra Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Manoj Bhadiyadra Commented 1 Years ago through Just Learned
Guenter,
Thanks for the information.
Can you provide few more details like how many rows u have and when it -TVF starts behaving like this.
Thanks
Manoj...
|
-
Manoj Bhadiyadra Commented 1 Years ago through Just Learned
Guenter,
Thanks for the information.
Can you provide few more details like how many rows u have and when it -TVF starts behaving like this.
Thanks
Manoj...
|
-
Manoj Bhadiyadra Question Asked 1 Years ago through ASK
Though you have set QUOTED_IDENTIFIER at database level, is it require to set at object level also to take effect??...
|
ask
98
·
2% ·
538
|
|
-
Manoj Bhadiyadra Posted 1 Years ago through Ask
Though you have set QUOTED_IDENTIFIER at database level, is it require to set at object level also to take effect??
...
|
-
Manoj Bhadiyadra Answered 2 Years ago through Quizzes
Some of the new Dynamic Management Views (DMVs)
Transaction related (sys.dmtranactivetransactions, sys.dmtrandatabasetransactions, sys.dmtranlocks, sys.dmtransession_transactions )
Execution related (sys.dmexecconnections, sys.dmexecqueryplan, sy...
|
-
Manoj Bhadiyadra Answered 2 Years ago through Quizzes
1) Using DBCC Command -
a) DBCC TRACEON (3604) -- looking page content
go
DBCC PAGE ('AdventureWorks2008R2',1,9,3)
GO
DBCC TRACEOFF (3604)
GO
DBCC TRACEON (3604);
GO
DBCC DBINFO ('AdventureWorks2008R2')
GO
DBCC TRACE...
|