|
|
-
Ashish Gilhotra Liked 9 Days ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
sirknth Question Received 4 Months ago through ASK
i have table called test it contains number of columns. there are some columns named loadnum,foh,roh,date. for each date it has 10 loadnumbers, each load contains 10 rows with load number1, another 10 rows load number2, for load number 1 foh and roh should...
|
-
Ashish Gilhotra Liked 9 Months ago through Just Learned
During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...
|
-
Ashish Gilhotra knew 9 Months ago through Just Learned
During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...
|
-
Ashish Gilhotra Liked 9 Months ago through Just Learned
During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name "Ma
|
-
Ashish Gilhotra Liked 9 Months ago through Blogs
In a perfect world, any table once designed would never undergo any modifications for the entire life of the product. However, nothing’s perfect and as they say – the only thing that’s constant is that nothing’s constant. Similarly, requirements change ...
|
-
Ashish Gilhotra Liked 9 Months ago through Just Learned
Just learned from pinal's blog that by using SSMS, we can generate various reports also. Suppose, we can generate the report of top queries by average CPU Time or average IO Time etc.
In SSMS, Right click on server name-> Reports -> Standard Re...
|
-
Ashish Gilhotra knew 9 Months ago through Just Learned
Just learned from pinal's blog that by using SSMS, we can generate various reports also. Suppose, we can generate the report of top queries by average CPU Time or average IO Time etc.
In SSMS, Right click on server name-> Reports -> Standard Re...
|
-
Ashish Gilhotra Liked 9 Months ago through Just Learned
i just learned today, one new thing , "how to find index fragmentation details of all tables in database with using system function sys.dm_db_index_physical_stats." Check out following query.
[code]
Select object_name(a.object_id) AS Table_Name, ...
|
-
Ashish Gilhotra knew 9 Months ago through Just Learned
i just learned today, one new thing , "how to find index fragmentation details of all tables in database with using system function sys.dm_db_index_physical_stats." Check out following query.
[code]
Select object_name(a.object_id) AS Table_Name, ...
|