Viewing 15 posts - 6,796 through 6,810 (of 8,753 total)
skb 44459 (10/12/2014)
i was able to connect using sql studio using 'SRVDR' as Server Name.
Also other application was able to use server name 'SRVDR'
We changed...
October 12, 2014 at 10:34 pm
Haven't experienced the 0 duration, must improve the harness, using this quite a lot, all suggestions welcome;-)
😎
October 12, 2014 at 2:00 pm
This is on a mediocre i5 laptop (E6220), single SSD (3rd gen) and SQL Server 2014, similar results on both 2012 and 2008 R2 on the same system. Tempdb has...
October 12, 2014 at 1:18 pm
rym2001 (10/12/2014)
October 12, 2014 at 12:45 pm
rym2001 (10/12/2014)
October 12, 2014 at 11:54 am
Jason Shadonix (10/12/2014)
Eirikur Eiriksson (10/12/2014)
Quick thought, check the file system permissions for the account on the folder specified (<path>)😎
I finally figured this out. I'm not exactly sure why my...
October 12, 2014 at 10:38 am
dcarter 43846 (10/12/2014)
I did try to delete this topic as it was a duplicate but couldn't find the button!
No worries;-)
😎
October 12, 2014 at 6:59 am
Duplicate topic, answer here
😎
October 12, 2014 at 6:49 am
Quick thought, be careful when implementing a trigger with a single value logic and a transaction rollback, chances are that this will cause problems down the line. A more robust...
October 12, 2014 at 6:45 am
Probably one of the most important factors here is the index maintenance, as the "health" of the index can greatly affect the performance, even in some not so exceptional cases....
October 12, 2014 at 5:12 am
Quick thought, check the file system permissions for the account on the folder specified (<path>)
😎
October 12, 2014 at 2:06 am
Digging slightly deeper into this in order to explain this behaviour:
1) Without the parenthesis, this is a simple select query and the server scans the table for all matching entries....
October 11, 2014 at 11:28 pm
dcarter 43846 (10/11/2014)
I have a source table with an xml column that I need to query on the nodes and then depending on what data is in the node then...
October 11, 2014 at 9:58 pm
Quick thought, the former returns an empty set and no assignment takes place, the latter returns a set with a empty (null) column whitch is assigned to the variable.
😎
October 11, 2014 at 12:46 pm
Junglee_George (10/10/2014)
I can remove this DISTINCT keyword from the query once the OUTER APLLY is changed to...
October 11, 2014 at 12:12 pm
Viewing 15 posts - 6,796 through 6,810 (of 8,753 total)