|
|
-
|
|
You all know about the database file structure as whenever we created databases without specifying file location and filegroups , they will be created in default path and default filegroup. Here i have tried to created a new database without defining an...
|
|
-
|
|
Is it possible to use PIVOT keyword with out using aggregate functions.
Options:
1.Yes
2. No
3. Other
ANSWER:___________
Condition: Select appropriate answers from the options and if non of the answer is suitable for the question or if you want to expla...
|
|
-
|
|
Data Explorer is generating a lot of positive buzz within the community and everyone I speak to seems to be really excited about this. (If you are wondering what Data Explorer is, you might want to quickly catch up on my previous post - Introduction to ...
|
|
-
|
|
Bill is the sales director of a certain pharmaceutical company. He is in urgent need to prepare a certain product sales report to impress the clients in an important bidding event. This report requires presenting the monthly sales value, monthly growth, and year-over-year growth of these 3 products....
|
|
-
|
|
TRUNCATE Command belongs to____________Options:1. DDL2. DML3. Both (DDL & DML)4. OthersANSWERE____________Condition: Select appropriate answers from the options and if non of the answer is suitable for the question or if you want to explain with ...
|
|
-
|
|
Insert a value in table which has only Identity column automatically without specifying any hard value for that column. No identity_insert ON/OFF.....
|
|
-
|
|
In this post, we take a look at the Catalog Views related to columnstore indexes introduced in SQL Server 2012: sys.column_store_segments and sys.column_store_dictionaries....
|
|
-
|
|
How to retrieve first 50 records from a tableOptions:1. Using TOP Command2. Using ROW_NUMBER() function3, Using both TOP and ROW_NUMBER()4. OthersANSWER: ____________Hi all,FILL IN THE BLANKS Series is a kind of posts related to objective type questions...
|
|
-
|
|
Assume that you have two identical tables in different servers. The table in production server has 100 million rows and the table in test server is empty and you want to transfer data from production server into test server to do some analysis based on ...
|
|
-
|
|
As new features are added to products, the underlying database objects undergo changes. Whenever such changes are made, the underlying meta-data for the dependent objects also needs to be updated. The meta-data for non-schema bound views can be refreshed using a system stored procedure - sp_refreshview....
|
|