How to open and view a deadlock graph .xdl file with SSMS ?
How to open and view a deadlock .xdl file with SSMS ?
Solution 1 :
On the File menu in SQL Server...
2012-11-09
2,336 reads
MSSQLFUN
SQL Server 2012 SP1 Is Now Available !
After a wait of around 8 months, Microsoft has released SQL Server 2012 SP1.
Microsoft SQL Server team has released SQL...
2012-11-08
944 reads
How to save deadlock graph events as .xdl file in SQL Server ?
How to save deadlock graph events as .xdl file ?
On the File menu, click New Trace, and then connect to...
2012-11-14 (first published: 2012-11-07)
3,592 reads
SQL Server – List of all the Error codes or messages
Question:
I want list of all error codes & messages of SQL server.
Answer:
Once some ask this thing to you or this though...
2012-11-05
34,183 reads
Come Back From vacations…..
Hey Friends
I missed you so much in my vacations.
I come back from my leaves & hope now we have regular interactions.
2012-11-05
536 reads
SQL Server 2012 CU4 Is Now Available !
The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...
2012-10-16
740 reads
Multilanguage Table, How to insert different language text in table ?
Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...
2012-10-15
2,984 reads
IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM
Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...
2012-10-15
584 reads
How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....
2012-10-12
1,057 reads
SQL Server 2012 SP1 CTP4 Is Now Available !
Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...
2012-10-11
705 reads
Blogs
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers