Viewing 15 posts - 31 through 45 (of 210 total)
Stephanie Giovannini (5/5/2015)
The system_type_id for decimal and numeric is not the...
May 6, 2015 at 7:36 am
I have created a test table with 9 columns covering all the given data types, then found the answer is 5. Thanks for the question
create table test_tbl
(
col_1 DECIMAL(12,0),
col_2 REAL,
col_3 DOUBLE...
May 5, 2015 at 3:26 am
do you have the "bob" in your db users list ?
May 4, 2015 at 7:01 am
Try the below query. hope it will suffice your requirement
SELECT SCHEMA_NAME(schema_id) + '.' + name TableName
, type_desc
, HAS_PERMS_BY_NAME(SCHEMA_NAME(schema_id) + '.' + name,
'OBJECT', 'SELECT') AS have_select
, HAS_PERMS_BY_NAME(SCHEMA_NAME(schema_id) + '.' + name,
'OBJECT',...
May 4, 2015 at 6:19 am
Graham_Day (4/23/2015)
Excellent illustration of how query folding and constant evaluation is used by the query optimizer. Many thanks Carlo.
+1
April 23, 2015 at 3:25 am
sestell1 (4/22/2015)
Interesting question! I don't use filtered indexes very often, and didn't know filtered indexes had these limitations.
+1
April 22, 2015 at 7:26 am
Ed Wagner (4/21/2015)
Good question. Not knowing the answer off the top of my head, it was more a process of elimination than anything. Thanks.
+1
April 21, 2015 at 6:12 am
mohan.bndr (4/13/2015)
peterus (1/3/2006)
Try DBCC OUTPUTBUFFER (spid) . Where spid is the backup process. This is as or more accurate than the stats option.
I see the DBCC inputbuffer (spid) will give...
April 14, 2015 at 12:15 am
jpatenaude (4/9/2015)
April 9, 2015 at 6:57 am
SQL-DBA-01 (3/31/2015)
I think the reference link which you posted is not appropriate.USe this:
https://technet.microsoft.com/en-us/library/ms175477(v=sql.110).aspx
I think the link is appropriate.
https://msdn.microsoft.com/en-us/library/ms189253.aspx
or
https://msdn.microsoft.com/en-IN/library/ms189253%28v=sql.120%29.aspx
It has the below statements
"
Limitations and...
March 31, 2015 at 9:24 am
Rune Bivrin (3/26/2015)
Let's assume that there's no output file already there in the location.
If the file is already available in the location, will it write anything to the file?
Which is...
March 26, 2015 at 3:21 am
i know the answer is straight away no since there is syntax error. :rolleyes:
but clicked the answer "yes":crying: thinking that there might be any trick which i have missed
March 26, 2015 at 12:32 am
The below script gives a hint that both the tables will be created successfully
drop table junk, #temp;
so two answers are partially revealed, only one more option to check 🙂
March 25, 2015 at 3:11 am
Viewing 15 posts - 31 through 45 (of 210 total)