Viewing 15 posts - 241 through 255 (of 1,179 total)
I guess the objective to test the subjective knowledge hence T-SQL should be well formated and easy to understand.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2014 at 1:01 am
You need to rebuild the indexes where the scan density is lower. Also do not bother if the table is small i.e. pages are less. Refer following link for further...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2014 at 12:28 am
Interesting question, thank you Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2014 at 12:03 am
It would be good to have one instance instead of multiple instance as allocation of the resource might be challange. You can think of seperate instance if you would like...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 5:13 am
check this out...
http://www.sqlservercentral.com/blogs/sqlrnnr/2010/04/27/blob-index-columns/
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 3:59 am
Information is not sufficient to provide any conclusion. You need to have web based front end to input data. What about the backend? How is your database design? How users...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 2:51 am
Easy one. Thank you!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 12:21 am
Thank you! for question on new feature of SQL 2014.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 12:17 am
Easy one.
Thanks!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2014 at 12:10 am
Agreed with Gail. You are using SQL login and want the info of windows login? There is no logic.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 3:37 am
What kind of System File?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 3:35 am
Looks like permission issue. Do you have permission to access this database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 3:25 am
Do you have sysadmin privilages on the server?
If yes enable option 'Ad Hoc Distributed Queries' in configuration by executing 'sp_configure' (with enabling advance option on).
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 2:49 am
yuvipoy (4/16/2014)
What will happen when the server is restarted will index be recreated?
NO. There is no relation between server restart and index.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 2:42 am
You mean due to SSIS package database size is growing on C:?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 2:33 am
Viewing 15 posts - 241 through 255 (of 1,179 total)